After Paste Value and Replace
 

Are you replacing the errors (like #n/a) with a space character? If you are,
then leave that "with:" field empty.

But if your formulas looked like:
=if(a1=7,"ok","")

then this may help...

Saved from a previous post:

If you want to see what's left in that cell after you convert ="" to values,
try:
Tools|Options|Transition Tab
Toggle Transition Navigation keys on.

Then select on of those cells and look at the formula bar. You'll see an
apostrophe. (Don't forget to toggle the setting to off.)

When I want to clean up this detritus, I do this:

Select the range (ctrl-a a few times to select all the cells)
Edit|Replace
what: (leave blank)
with: $$$$$
replace all

Immediately followed by:
Edit|Replace
what: $$$$$
with: (leave blank)
replace all

If you need to do this lots, you can record a macro when you do it manually.

Tom wrote:

When I copy and paste value and there are some error values which I replace
with nothing. Only there is something there. On the screen the cell shows
empty and when I select the cell and backspace there seems to be nothing
there. When I evaluate using isblank() or istext() or isnumber(), it acts
like it has text in it. I can select the cell and delete and then it
actually acts as if it is empty.

What is going on and how can I get rid of what is causing this?
--
Tom

--

Dave Peterson