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.

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.

Multiple Find and Replace in one function
 

Try this:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," Corp. ","")," Inc. ","")," Co. ","")

Note that Substitute is case sensitive. <spcorp.<sp will not match
<spCorp.<sp

Biff

wrote in message
ups.com...
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.

Multiple Find and Replace in one function
 

Awesome! Thanks!
Biff wrote:
Try this:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," Corp. ","")," Inc. ","")," Co. ","")

Note that Substitute is case sensitive. <spcorp.<sp will not match
<spCorp.<sp

Biff

wrote in message
ups.com...
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.

Multiple Find and Replace in one function
 

You're welcome!

Biff

wrote in message
oups.com...
Awesome! Thanks!
Biff wrote:
Try this:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," Corp. ","")," Inc. ","")," Co.
","")

Note that Substitute is case sensitive. <spcorp.<sp will not match
<spCorp.<sp

Biff

wrote in message
ups.com...
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.