V VickiMc Feb 12, 2009 #1 How do I find the contents of one cell that could be anywhere in the text of a second cell?
P Pete_UK Feb 12, 2009 #2 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
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
