Hi

From where are you? Or more important, what are your Windows regional
settings? When there is a semicolon selected as list delimiter , then use
it instead of comma in formula!


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"Doom3" wrote in message
...
I can't figure out the way of doing it. There is a note about it on
microsoft
web site You can count the number of words in a cell by using the
following
formula:

=IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1)

But it's not working. I can't even enter this formula since exell
complains
every time that formula is not correct.

Any ideas?