Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
=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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a limit to number of words in a cell in excel? | Excel Discussion (Misc queries) | |||
I need to increase a number which is held in a cell by 1 | New Users to Excel | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
how to count the nr of occurrences of a text string in a cell rang | Excel Worksheet Functions |