Replacing ~ with text

J

John Holland

i have a spreadsheet that gets delivered and some of the cells simply
contain a "~".

i want to replace the "~' with "N/A".

however, when I use the Edit:Replace command, get a message back that says:

"Microsoft Office Excel cannot find any data to replace. Check if your searc
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."

This worksheet is definitely NOT protected. Help!
 
A

Andy B

Hi

~ is a special character to Excel. To Find it you'll need to use two of them
~~
 

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 and replace all error message 3
Copy to new sheet replacing existing data 2
How to really protect cell formatting in a protected sheet 2
Ex07 in '03 Format - Change format if information changes 2
Changing Cell Colour in Protected Sheet 1
Transfer Spreadsheet method Not replacing Sheet Name 2
Something New 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Top