S
soniadufferin
How do I create a formula to count Text in Cells?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tim M
Can you elaborate? do you want to count the number of cells that have text
or do you want to actually count the number of letters of text in each cell?
or do you want to actually count the number of letters of text in each cell?
B
Bob Phillips
Probably
=COUNTIF(A:A,"text")
or maybe
=COUNTIF(A:A,"*text*")
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
=COUNTIF(A:A,"text")
or maybe
=COUNTIF(A:A,"*text*")
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
P
Peo Sjoblom
=LEN(A1)
will count all characters in a cell,
=COUNTIF(C1:C10,"*")
will count cells with text
if that is not what you want post back
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
will count all characters in a cell,
=COUNTIF(C1:C10,"*")
will count cells with text
if that is not what you want post back
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
R
RagDyeR
Do you mean count characters (including spaces):
=LEN(A1)
Don't count spaces:
=LEN(SUBSTITUTE(A1," ",""))
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
How do I create a formula to count Text in Cells?
=LEN(A1)
Don't count spaces:
=LEN(SUBSTITUTE(A1," ",""))
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
How do I create a formula to count Text in Cells?