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 [email protected]> wrote in message
news:[email protected]...
>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.