- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Re: Creat Formula for Counting Text

Subject: | Re: Creat Formula for Counting Text |

Posted by: | Bob Phillips (bob.N…@googlemailxxx.com) |

Date: | Wed, 10 May 2006 |

Probably

=COUNTIF(A:A,"text")

or maybe

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

--

HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

None

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