| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find and replace part of a text string
Why not use EDIT==Find==Replace?
" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find and replace part of a text string
Edwin, Go to EDITREPLACE Under the Replace tab in "Find what: type Llc In Replace with: type LLC click the options button lower right and select Match case and make sure Match entire cell contents is not selected. HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=560081 |
| Reply |
| 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 | |||
Hybrid Mode
