Go to Blanks doesn't highlight all blanks

[andydtaylor]

Hi,

Please help this is driving me mad!

The problem is, I do go to blanks and loads of seemingly blank cells are not highlighted. The cells previously contained formulas which are no longer present (I copy/paste special'd)

In the blank cells which are not highlighted there are no spaces. If I say 'text-to-columns, format general' nothing happens, however if I double-click in each troublesome cell they get picked up as being blank.

I also tried copy/paste multiply to no avail.

Any ideas appreciated.

Thanks,

Andrdew

 

[Richard Schollar]

Hello Andrew

If you ar using Edit>Goto>Special>Blanks then be aware that it only identifies the blanks in the UsedRange (think this is correct) - so cells outside of it won't be selected.

Also, there are other characters that can appear as 'blanks' while not really being so (eg Ascii character 160) - potentially this might be causing you problems.

 

[andydtaylor]

Hi Richard, thanks for that.

I think you're right with the jedi character! My solution was to replace "" with "@" and then to replace "@" with guess what? Yep, ""... which solved the problem.

Pretty wild, but it's solved for the time being!

Thanks,

Andrew