If cell H1 is empty, =TRIM(SUBSTITUTE(SUBSTITUTE(E1,G1,""),C1,""))
On Tue, Jul 20, 2010 at 1:26 PM, Chris Blair <[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] ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
