View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Angus Angus is offline
external usenet poster
 
Posts: 81
Default Delete defined text in a column

I got a column for some "company names" but I want to remove those "Co",
"company", "inc." etc, or "Atlanta", "L.A.", etc; I put those "to be removed"
text in another column so that all text in this column will be removed from
the company name column, eg.

Newell co, L.A. should be read as Newell
IBM Global Services Ltd, USA should be read as IBM Global Services
Australia Home Depot Inc. should be read as Home Depot