| 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. |
| 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) | |||
Threaded Mode
