How do I create a formula to count Text in Cells?

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?

"soniadufferin" wrote:

How do I create a formula to count Text in Cells?

Probably

=COUNTIF(A:A,"text")

or maybe

=COUNTIF(A:A,"*text*")

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"soniadufferin" wrote in message
...
How do I create a formula to count Text in Cells?

=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



"soniadufferin" wrote in message
...
How do I create a formula to count Text in Cells?

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!
================================================== ===


"soniadufferin" wrote in message
...
How do I create a formula to count Text in Cells?