ExcelBanter - Find Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find Function (https://www.excelbanter.com/excel-worksheet-functions/220525-find-function.html)

VickiMc

Find Function

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

Pete_UK

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?

All times are GMT +1. The time now is 07:02 PM.