-
Sorry to be coming in late, but I would have solved this just using qorksheet functions, namely VLOOKUP. Somewhere on the sheet create a table like this: A 110 - A B 120 - B C 130 - C D 140 - D Then in a cell adjacent to the cell you wish to replace, enter a vlookup formula along the lines of: =vlookup...
-
I have a spreadsheet of addresses that was scanned using OCR. The scanner did an acceptable job of text recognition, however due to additional Title's (i.e. MD, PhD, RN, etc) the columns in excel became wildly unmanageable. I need to extract Telephone, Fax and E-mail from a long list of contacts...