Blank but not empty cell

[Guest]

Hi,
I have imported data from an external file into excel. Some of the cells seems to be blank but obviously not empty!!
They have length (4) and they do not "behave" as empty cells.
How can I transform them to blanks?
Eli

 

[Matanuska]

Try selecting Edit/Replace... from the main Excel menubar and type a single space in the Find What box, leave the Replace With box blank, and Replace All.

This trick also works wonders when imported data refuses to plot correctly (spaces can cause all sorts of problems).