Count the number of words in a cell!

[Guest]

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?

 

[Don Guillett]

I just tested and it worked just fine,even with a mixture of text and
numbers
aaaa 1a11 bbb c 2 e2ee3

 

[Myrna Larson]

I just pasted the formula from the message into a worksheet. It is
syntactically and logicall correct as written -- I got no errors, and it
returned the correct result.

 

[Max]

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

Copied and pasted the formula above into Excel 97
Excel 97 accepted it w/o errors, and it works ok, too ..

 

[Arvi Laanemets]

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!