Hi,

Quick question. Below I have 5 cells of text in range A1:A5, is it possible to count the amount of times the capital word appears? Example below:

Very stiff extremely high strength dark greenish grey silty CLAY with...
Dark greenish grey slightly clayey silty fine to medium SAND with...
Very stiff extremely high strength dark greenish grey silty CLAY with...
Very stiff extremely high strength dark greenish grey silty CLAY with...
Dark greenish grey slightly clayey silty fine to medium SAND with...

The answer would be

SAND:2
CLAY:3

Thanks for any help