Re: Creat Formula for Counting Text

Giganews Newsgroups
Subject: Re: Creat Formula for Counting Text
Posted by:  Ragdyer (RagDy…@cutoutmsn.com)
Date: Wed, 10 May 2006

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" <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