I have a set of data name address and phone..... that I imported into Excel using OCR software from a printed list and the best I could get the information into excel was all in one cell so the cell reads (Jane Smith ####### 1234 main street ##### 444/555-9876 ## Your Town, US 55889 ### Fax 555/784-9999 ## jsmith@smith.com) # = spaces. I have been able to break out the name and the phone and fax using Formulas like FIND, LEFT, MID But I am not sure how I extract the address and the email because there is not pattern. The data wizard is not working either because the spaces are not consistant between the informatin in all cells. Any suggestions ?
2007-02-22
06:32:03
·
5 answers
·
asked by
anneonceagain
2