Count words between a certain criteria

[Lorene]

I have an excel spreadsheet that is numbers and words. Example: .25 and ABSE, VAC. I want to count how many times the words appear between a certain criteria. example: A3 - L110. How can I calculate the difference words that I am looking for?

[davesexcel]

http://www.excelforum.com/showthread.php?t=480524

[Lorene]

Thank you so much!! This made my life a lot easier than counting each separate word.

[davesexcel]

Great..
I hope it works for you...