Perfect! Thanks for the help
From: Michael White [mailto:[email protected]] Sent: Tuesday, July 20, 2010 3:38 PM To: NT System Admin Issues Subject: Re: OT:Excel Question If cell H1 is empty, =TRIM(SUBSTITUTE(SUBSTITUTE(E1,G1,""),C1,"")) On Tue, Jul 20, 2010 at 1:26 PM, Chris Blair <[email protected]<mailto:[email protected]>> wrote: 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! -- -- Michael S. White [email protected]<mailto:[email protected]> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
