Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace | Excel Discussion (Misc queries) | |||
find and replace, within workbook | Excel Discussion (Misc queries) | |||
Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
VB Find and Replace | Excel Worksheet Functions |