-
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...
-
Roger and David, Thankyou both for your help. Regarding the use of offset, to she some more light on it's use I will describe the layout of my data: The cells with the lookup formulas are arranged in tables of 9x9 cells, the tables are laid out 2 across, and 64 down the sheet. The look-up value for...
-
Not familiar with Excel for the Mac, but in windows it's F4 not F5, F5 displays the Goto... box If you look up keyboard shortcuts in help if it doesn't work with F4 you should get an answer post back if not