Try testing Len(Trim(value)) for 0.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tatebana" wrote in message
...
The problem is: some cells contain " " (1 spaces, others " "(2), others "
"(3), etc.

I can get away with it with replacing all spaces and later put them in
again.


"Bob Phillips" wrote:

test for "", or do you actually mean a space, in which case test for " "

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Tatebana" wrote in message
...
Oh my God! As I copied the data from the net, I oversaw that the
"empty"
cells contained blanks...! Shame on me.

That, however could lead to the question: Can these blanks be detected?
I
could replace them first, of course with a simple formula, but that
would
also eliminate the blanks in text, where they are necessary.