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/> ~
