Cells that appear empty

[DAddison]

I am seeking a function or command that will allow me to convert cells in Excel to blank. When Excel data is imported it is useful to reformat or clean up the data with tools from ASAP that hide or delete cells if they are blank. The problem is cells appear blank on the screen but must contain hidden data or format issues that prevent the ASAP utilities from promper execution.

Does anyone have a tool that can convert cells to blank?

Thanks

 

[Andrew Poulsom]

If A1 is one of your "blank" cells, what does:

=CODE(LEFT(A1))

return?

 

[daniels012]

Like ClearContents in a certain range?
Or Clear all cells on a worksheet?

Michael

 

[DAddison]

Andrew:

Thanks for the reply.

When I execute your =Code(left(a1))
The cell returns "#Value" nothing can be seen in the cell