Rowhouse Logic - Breathtaking Inanity

I don’t usually put up random links to random sites I think are cool, but 10×10 is worth an exception. The site provides a graphic portrait of the 100 most used words appearing on the RSS feeds of Reuters World News, BBC World Edition, and the New York Times. Each word is represented by a small picture and the overall picture generated is updated hourly, without human intervention.

Computer Professionals of Center City (CPCC) will be hosting a networking event in the near future:

Date/Time: Tuesday, February 15, 2005 7:00 PM

Where: The Irish Pub, 2007 Walnut Street, Philadelphia, PA

Cost: Free with cash bar. RSVP for a free pre-printed nametag.

Contact: David Lynn, Webmaster, webmaster@cpcentercity.com, or visit the website, cpcentercity.com.

Note: See the web site for a list of event dates thru September 2005

CPCC - For IT Types Of All Stripes!

I promise I’ll never do this again. Really, I do.

I may have mentioned previously, that I spend entirely too much time with Excel. Well it’s true, I do. I hope to stop soon. Actually, I meant to stop a long time ago. So anyway, let me share one of the fruits of my misery.

This formula will extract an email address out of a text string of any length, regardless of where in the text string the email address is located. It will always take the first email address found and no others. The formula will return an error if none is found. The example provided, assumes that the string is in cell A2. Adjust accordingly.

=IF(ISERR(LEN(LEFT(A2,SEARCH(”@”,A2)))-FIND(”*”,SUBSTITUTE(LEFT(A2,SEARCH(”@”,A2)),” “,”*”,LEN(LEFT(A2,SEARCH(”@”,A2)))-LEN(SUBSTITUTE(LEFT(A2,SEARCH(”@”,A2)),” “,”"))))),LEFT(A2,FIND(”@”,A2)),RIGHT(LEFT(A2,SEARCH(”@”,A2)),LEN(LEFT(A2,SEARCH(”@”,A2)))-FIND(”*”,SUBSTITUTE(LEFT(A2,SEARCH(”@”,A2)),” “,”*”,LEN(LEFT(A2,SEARCH(”@”,A2)))-LEN(SUBSTITUTE(LEFT(A2,SEARCH(”@”,A2)),” “,”"))))))&IF(ISERR(FIND(” “,RIGHT(A2,LEN(A2)-FIND(”@”,A2)))),RIGHT(A2,LEN(A2)-FIND(”@”,A2)),LEFT(RIGHT(A2,LEN(A2)-FIND(”@”,A2)),FIND(” “,RIGHT(A2,LEN(A2)-FIND(”@”,A2)))))

Why would you ever use this? Well, if you had any sense you wouldn’t. Sense and sensibility are not my province, however.

Again, enjoy this crap while you can, I’ll never do it again.

Computer Professionals of Center City is pleased to announce it’s next two networking events:

Tuesday, December 14, 2004 7:00-9:00 pm

Tuesday, January 18, 2004 7:00-9:00 pm

Location: The Irish Pub in Center City Philadelphia at 2007 Walnut Street. Events are free with cash bar. If you register in advance, we will have a pre-printed nametag ready for you.

Dress code is business-casual. Click here to email our webmaster, David, who will put you on the registration list and send you an email confirmation. Please remember to include your name as you would like it to appear on your nametag, as well as your company name and/or title if you would like.

If you knew how much of my life I’ve lost staring at Excel spreadsheets, you would understand my glee at learning that Micrsoft doesn’t own the name.