To get just the address use this formula in a new column =RIGHT(E2,LEN(E2)-(SEARCH(G2,E2)+LEN(G2)))
Regards, Phil Garven ________________________________ 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/> ~
