Find and replace in excel

C

ChrisB

when I try a find a replace, it finds everything fine, but when I try
to replace with nothing (or a blank space) it will not work, any
suggestions ?
 
C

ChrisB

"select all" im assuming you mean replace all? I do replace all, and
get this error with Excel:

"Microsoft Office Excel cannot find any data to replace. Check if your
search formatting and criteria are defined correctly. If you are sure
that matching data exists in this workbook, it may be on a protected
sheet. Excel cannot replace data on a protected worksheet."


Now I am positive it found data, it found about 1672 cells. Im not so
sure as to what a protected worksheet is, but this is the error coming
across, any ideas?

thanks in advance everyone!
 

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

Numbers change in cell even when formatted as text 4
Find and Replace Command Using Wildcard Help 1
Replace with wildcards 2
How come it say "Microsoft Excel cannot find any data to replace"? 4
find part text, replace all text 4
Use Find and Replace in Excel 2
Replace 1
Find and Replace error 3

Top