Tag Archive: excel

Feb 01

Doing math on a selection of cells in Excel

Why do I keep forgetting this? ┬áTo do math on a selection of cells in Excel (like making all the numbers negative for example) type the new number in a blank cell (-1 for this example), copy it select the cells you want to do the math to pick paste special pick the correct math …

Continue reading »

Aug 29

Convoluted Matching using Expression Web and Excel

Today, I was able to take a list if the customer names and account numbers from a text file and associate them with the account numbers in an excel file. First, I filtered the list (accepting only lines with a "-" in them). replaced… {.*}{[0-9][0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]}{.*} …with… 1t2t3 …in Expression Web. Then, I pasted that to …

Continue reading »

May 30

Filtering e-mail addresses from a huge mound of plain-text

I'm faced with a mailbox full of bounced/undeliverable messages and from that I need to extract all the e-mail addresses that need to be removed from our home-spun mass-mail program. After messing around a whole bunch, installing a whole mess of different editors and tools that I downloaded from the internet, and wasting a lot …

Continue reading »