Thread: Find Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?