| 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) | |||
Hybrid Mode
