Find and Replace
 

Is there a way to use the "find and replace" function to find and delete
words? I have a spreadsheet that has a column of cells with product
descriptions in them. Each description contains the manufacturer's
name, which I don't need. I did a find and replace of the of
manufacturer name and didn't put anything in the replace with box, but
it didn't do anything. Is it possible to find and delete? I could do
it with a space, but I would rather not.

Thanks


--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926
View this thread: http://www.excelforum.com/showthread...hreadid=493641

Find and Replace
 

Perhaps you had "Match entire cell contents" checked under
EditReplaceOptions.

Uncheck and try again with nothing in the Replace With: box


Gord Dibben Excel MVP

On Wed, 14 Dec 2005 17:30:37 -0600, blakrapter
wrote:


Is there a way to use the "find and replace" function to find and delete
words? I have a spreadsheet that has a column of cells with product
descriptions in them. Each description contains the manufacturer's
name, which I don't need. I did a find and replace of the of
manufacturer name and didn't put anything in the replace with box, but
it didn't do anything. Is it possible to find and delete? I could do
it with a space, but I would rather not.

Thanks

Find and Replace
 

Finding and replacing with nothing works for me.

Maybe you had a range selected other than the range that you intended to
perform the operation on.



"blakrapter" wrote:


Is there a way to use the "find and replace" function to find and delete
words? I have a spreadsheet that has a column of cells with product
descriptions in them. Each description contains the manufacturer's
name, which I don't need. I did a find and replace of the of
manufacturer name and didn't put anything in the replace with box, but
it didn't do anything. Is it possible to find and delete? I could do
it with a space, but I would rather not.

Thanks


--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926
View this thread: http://www.excelforum.com/showthread...hreadid=493641

Find and Replace
 

"blakrapter" wrote:


Is there a way to use the "find and replace" function to find and delete
words? I have a spreadsheet that has a column of cells with product
descriptions in them. Each description contains the manufacturer's
name, which I don't need. I did a find and replace of the of
manufacturer name and didn't put anything in the replace with box, but
it didn't do anything. Is it possible to find and delete? I could do
it with a space, but I would rather not.

Thanks


--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926
View this thread: http://www.excelforum.com/showthread...hreadid=493641