Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find & Replace text format jmn13 Excel Discussion (Misc queries) 2 May 25th 06 06:18 PM
Find and replace should work in Excel text boxes Bob@Teton Excel Discussion (Misc queries) 0 October 20th 05 01:16 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Excel - Find & Replace text in a string bklim Excel Worksheet Functions 1 June 14th 05 06:42 AM
Creating a macro to find and replace text Louise Excel Worksheet Functions 10 June 8th 05 10:29 AM


All times are GMT +1. The time now is 11:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"