Count the number of words in a cell!
 

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?

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

--
Don Guillett
SalesAid Software

"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?

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.

On Mon, 22 Nov 2004 17:15:01 -0800, "Doom3"
wrote:

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?

=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 ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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?

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?