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!
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!