cells which are blank but not (has space char)

[lezawang]

Hi
Lets say you have a big table and it has some cells which looks empty but has space as a character (user used spacebar to delete content). I know there are many way to spot these cells but I would like to learn different methods or how you would do it yourself. one option I can think of is to use isBlank() function. Thank you very much.

 

[Joe4]

You can use:

=" "

You can also use the LEN function to check to length.

A quick easy way to remove/fix them all at once is to use Find/Replace, replacing a single space with nothing.
Just be sure to go to the Options and check the "Match entire cell contents" check box so that you are only replacing values where a single space is the only thing in the cell (and you aren't removing spaces in between words).