Re: Creat Formula for Counting Text

Giganews Newsgroups
Subject: Re: Creat Formula for Counting Text
Posted by:  Peo Sjoblom (peo.sjobl…@nw^^excelsolutions.com)
Date: Wed, 10 May 2006

=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" <soniaduffer…@discussions.microsoft.com> wrote in message
news:D8FA6855-E70E-4099-83E5-CFDD56C82C…@microsoft.com...
> How do I create a formula to count Text in Cells?

Replies

None

In response to

Creat Formula for Counting Text posted by soniadufferin on Wed, 10 May 2006