software

Is there a way to use the quot;find and replacequot; 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: www.excelforum.com/member.php...oamp;userid=28926
View this thread: www.excelforum.com/showthread...hreadid=493641Perhaps you had quot;Match entire cell contentsquot; checked under
Editgt;Replacegt;Options.

Uncheck and try again with nothing in the Replace With: boxGord Dibben Excel MVP

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

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

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.
quot;blakrapterquot; wrote:

gt;
gt; Is there a way to use the quot;find and replacequot; function to find and delete
gt; words? I have a spreadsheet that has a column of cells with product
gt; descriptions in them. Each description contains the manufacturer's
gt; name, which I don't need. I did a find and replace of the of
gt; manufacturer name and didn't put anything in the replace with box, but
gt; it didn't do anything. Is it possible to find and delete? I could do
gt; it with a space, but I would rather not.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; blakrapter
gt; ------------------------------------------------------------------------
gt; blakrapter's Profile: www.excelforum.com/member.php...oamp;userid=28926
gt; View this thread: www.excelforum.com/showthread...hreadid=493641
gt;
gt;



quot;blakrapterquot; wrote:

gt;
gt; Is there a way to use the quot;find and replacequot; function to find and delete
gt; words? I have a spreadsheet that has a column of cells with product
gt; descriptions in them. Each description contains the manufacturer's
gt; name, which I don't need. I did a find and replace of the of
gt; manufacturer name and didn't put anything in the replace with box, but
gt; it didn't do anything. Is it possible to find and delete? I could do
gt; it with a space, but I would rather not.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; blakrapter
gt; ------------------------------------------------------------------------
gt; blakrapter's Profile: www.excelforum.com/member.php...oamp;userid=28926
gt; View this thread: www.excelforum.com/showthread...hreadid=493641
gt;
gt;