Worked Like a champ!!! Thankyou very much!!! I wish I had came here 2 hours
ago!!!

"Eduardo" wrote:

Hi,
try

=COUNTIF(A10:A13,"aa*")

replace aa for the word you are looking for and change the range to fit your
needs
if this helps please click yes thanks

"Stehy" wrote:

I am working in Excel 2003 and would like to enter a formula counting the
number of times a specific word (sometimes in a sentence) appears in a range
of cells. Does somebody know how ? Thank you !