Find and Replace

  • Thread starter Thread starter blakrapter
  • Start date Start date
B

blakrapter

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
 
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
 
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 said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find & Replace: find part cell, replace whole cell 2
How do I get Rid of the Circumflex Accent (Caret) 2
Find and replace for cells with certain number of characters. 8
End/Beginning of Cell Search/Replace? 1
using find and replace it's making me look in another file to upd 1
Find and Replace/Substitute Formulas 4
find and replace nonzero values with 1 3
find and replace units of a formula 3

Back
Top