software

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?

quot;soniadufferinquot; wrote:

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

Probably

=COUNTIF(A:A,quot;textquot;)

or maybe

=COUNTIF(A:A,quot;*text*quot;)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;soniadufferinquot; gt; wrote in message
news
gt; How do I create a formula to count Text in Cells?
gt;
=LEN(A1)will count all characters in a cell,=COUNTIF(C1:C10,quot;*quot;)

will count cells with textif that is not what you want post back

--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;soniadufferinquot; gt; wrote in message
news
gt; How do I create a formula to count Text in Cells?
gt;
Do you mean count characters (including spaces):

=LEN(A1)

Don't count spaces:

=LEN(SUBSTITUTE(A1,quot; quot;,quot;quot;))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===quot;soniadufferinquot; gt; wrote in message
news
How do I create a formula to count Text in Cells?