I have imported a text file from a payroll company that is formatted. Each
employee's name is moved to a new column - the first occurrence of a name is
in H6. The second occurrence of a name is in H18. When I try F5, special,
blank, OK = uparrow to cell above, Ctrl, Enter, Excel cannot find blanks -
even though the cell is "blank" there has to be something in it - I just
can't see it. When I press the Delete key in H7-17, and do the F5 routine,
it works. I've tried the Remove All Spaces macro, to no avail. Column H is
a copy, paste special values from another column that has formulas in 7-17.

Any ideas?

TIA