Testing to see if a cell is blank or contains only spaces

[hikerguy]

Hello,

I know of the ISBLANK feature, but that only works if a cell is truly empty (nothing in the cell and no space characters). Is there a function that would do this?

Alternatively, is there a way to remove all spaces from an empty cell?

Thanks,

Andy

 

[shg]

=len(trim(a1)) returns zero of a cell contains only spaces.

is there a way to remove all spaces from an empty cell?

An empty cell has no spaces, but to clear the contents of any cell, select and press Delete.

 

[hikerguy]

shg, It's a little hard to explain what I'm doing, but I have to account for a user hitting the space part in this template.

But, the good news is your suggestion was exactly what I was needing, so huge thanks!

 

[shg]

You're welcome.