Seems to me it might be easier to export to a CSV file and then re-import into Excel with column E split up into additional columns via the commas.
John-AldrichTile-Tools From: Chris Blair [mailto:[email protected]] Sent: Tuesday, July 20, 2010 4:26 PM To: NT System Admin Issues Subject: OT:Excel Question Sorry for the OT, but I know there are some Excel gurus hanging out here. I have 3 columns of data. Column C is the business name, Column E is the address, and column G is the contact. Column E also contains the same information as columns C and G, but contains no separators. Example, Column C = Business 101, Column E = Business 101 John Smith 123 Lane No Where, USA, Column G=John Smith My question, if this makes any sense, is to use columns C and G to remove that data from column E. Thanks! ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
<<image001.jpg>>
<<image002.jpg>>
