Counting Occurrence of Text within Text in Cells in Range.

G

Guest

I have a range, 11 wide by 47 tall. For discussion, we'll say it is 10 by 50.
I have strings of text within these cells, which may or may not include a
small string of text in the middle of the strings, such as "(LA)" within the
string "CA 101 - Introduction to Computers (LA) (CA 99, FND 101)" .
Each cell will be different, but many will have "(LA)" or other 4 or 5
character strings within the larger strings, like the one above.
I need a formula (hopefully in one cell) to count the number of times or
cells such a string "(LA)" appears within the larger strings in the cells in
this range.

Thanks in advance for giving your time to this dilemma.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top