Multiple Find and Replace in one function
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3," Corp.","")," Inc.","")," Co.","")
" wrote:
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.
|