Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Find and Replace function in Excel is not working? | Excel Worksheet Functions | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Help! - Lost function in Find & Replace! | Excel Discussion (Misc queries) | |||
HOW CAN I GET THE REPLACE FUNCTION TO DEFAULT TO FIND WHAT? | Excel Discussion (Misc queries) | |||
How can I do a find and replace for a cell that has multiple line. | Excel Discussion (Misc queries) |