| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and replace part of a text string
Help! I've been trying to figure out a formula for the following
problem, but I'm stumped. I have about 2,000 names such as the following beginning in cell A1: Scott Jameson MMSHRL Llc Hum Investments Ltd El Marcelago, Llc Lars Property Investments Llc I want to find all the "Llc" and replace it with "LLC". Scott Jameson MMSHRL LLC Hum Investments Ltd El Marcelago, LLC Lars Property Investments LLC Any help will be greatly appreciated. Thanks. Edwin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace text format | Excel Discussion (Misc queries) | |||
| Find and replace should work in Excel text boxes | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Excel - Find & Replace text in a string | Excel Worksheet Functions | |||
| Creating a macro to find and replace text | Excel Worksheet Functions | |||
Threaded Mode
