Words in a list beginning with a letter "C"

Hi folks

I am fiarly new to discussin boards and have a general question relating to Excel 07 please.

I wish to determine the number of words in a column that begin with a particular letter.


For example - Assume Cell A1 has the word DOG, A2 has CAT, A3 has CAR, A4 has TAR and A5 has PIG. Is there a formula that i can place into A6 that sums the number of words in the column from A1 to A5 that begin with the letter C. In this example the answer "2" would appear in A6 as there are 2 words in the list that commence with the letter "C".

Any feedback is greatly appreciated

Cheers

Jim

Hi and thanks for your quick reply, this does precisely what i needed it to. Good luck with finding a great job.

Cheers
Jim