Multiple Find and Replace in one function

  • Thread starter Thread starter bpkaufman
  • Start date Start date
B

bpkaufman

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.
 
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3," Corp.","")," Inc.","")," Co.","")
 
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3," Corp.","")," Inc.","")," Co.","")
 
Try this:

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

Note that Substitute is case sensitive. <sp>corp.<sp> will not match
<sp>Corp.<sp>

Biff
 
Try this:

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

Note that Substitute is case sensitive. <sp>corp.<sp> will not match
<sp>Corp.<sp>

Biff
 
Awesome! Thanks!
Biff said:
Try this:

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

Note that Substitute is case sensitive. <sp>corp.<sp> will not match
<sp>Corp.<sp>

Biff
Click to expand...
 
Awesome! Thanks!
Biff said:
Try this:

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

Note that Substitute is case sensitive. <sp>corp.<sp> will not match
<sp>Corp.<sp>

Biff
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX MIN function? 6
MS word Find and Replace using Regex - Help required 0
Multiple Criteria Find & Replace 3
Identify Duplicates (Group Records First) 6
Nested MID and FIND - OR? 3
Trying to find and replace * 4
Can VLookup function find and list multiple records? 11
Remove Specific Text - HELP! 6

Back
Top