I have an Excel worksheet which requires 'cleaning'. Specifically, there is a single column in which some of the cells appear blank. However, my VLOOKUP formulas have identified that some of these blank cells actually have hidden characters in them. If I do a LEN() on them they return a value of 1.
How can I create a little VBA procedure to identify and clear these rogue cells ?
Thanks in advance