Counting Occurrence of Text within Text in Cells in Range.
 

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.

Hi!

Try this:

=COUNTIF(A1:K47,"*(LA)*")

Biff

"Jeremy N." <Jeremy wrote in message
...
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.