Find Function
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?
|