Find a specific sentence in a cell full of text

Hi,

Very new here and very new to excel formulas.

Could you tell me how I can find a specific sentence within a cell that contains many sentences.

for example

I want to find, "I am new." within a text that contains, "Hello I am Bob. I am new. I live in england."

I am currently using =+FIND(AB$1,$V2) where AB1 contains the sentence I am looking for and V2 contains the cell full of sentences. However this returns #VALUE! when the sentence is not found. I want it to return null.

thanks in advance.

Ben

FIND is case-sensitive.. case-insensitive function equiv. is SEARCH ... try that...

and match has to be exact... not extra spaces within either string...

you also don't need the + sign in Excel after the = sign.

Oh, I misread your initial question... thought the function wasn't working for you when it should have found the string.

Try:

=IF(ISNUMBER(FIND(AB$1,$V2)),FIND(AB$1,$V2),0)

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save