Thread: Multiple Find and Replace in one function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] bpkaufman@gmail.com is offline
external usenet poster
  
Posts: 19
Default Multiple Find and Replace in one function
I'm wondering how I can clean one column of text using multiple find
arguments. This is what I have so far:

=MID(B3,1,FIND(" Corp.",B3,1)-1)

In addition to " Corp." I want to remove " Inc.", " Co." and a couple
other ones. Any help is much appreciated.

Reply With QuoteReply With Quote