andydtaylor
Active Member
- Joined
- Feb 15, 2007
- Messages
- 360
- Office Version
- 2016
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
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