How do I find the contents of one cell that could be anywhere in the text of
a second cell?

Like this:

=SEARCH(B1,A1)

A1 is the long string, B1 is the string you are looking. If it exists
in A1 the function returns a number - if not you get an error. Use
FIND instead of SEARCH if case is important.

Hope this helps.

Pete

On Feb 12, 2:17*am, VickiMc wrote:
How do I find the contents of one cell that could be anywhere in the text of
a second cell?