View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
working hard at home working hard at home is offline
external usenet poster
 
Posts: 3
Default Excel - Replace differant trailing words or symbyls with key word

How do I replace in multiple cells that start out with walgreen but have
mulitple differant endings to just walgreens.
example Walgreens5417 Q03 R 10/06WALGREENS
Walgreens5417 Q03 R 10/13WALGREENS