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 …
Tag: excel
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 …
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 …