Creat Formula for Counting Text
 

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

Creat Formula for Counting Text
 

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?

Creat Formula for Counting Text
 

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?

Creat Formula for Counting Text
 

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

Creat Formula for Counting Text
 

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?