Find and Replace

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

blakrapter - 14 Dec 2005 23:30 GMT

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

Thank

Reply to this Message

Gord Dibben - 15 Dec 2005 00:03 GMT

Perhaps you had "Match entire cell contents" checked under
Edit>Replace>Options.

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

Gord Dibben Excel MVP

>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
[quoted text clipped - 5 lines]
>
>Thanks

Reply to this Message

Roland - 15 Dec 2005 00:24 GMT

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.

> 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
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Roland - 15 Dec 2005 00:25 GMT

> 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
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message