hi,
In a cell, we have a text which composed by two or three word like this:
"Angelina Jolie"
I want to write a code and to determine if this cell has a text of "Jolie"
Is there a function that do this or how can I do ?
Printable View
hi,
In a cell, we have a text which composed by two or three word like this:
"Angelina Jolie"
I want to write a code and to determine if this cell has a text of "Jolie"
Is there a function that do this or how can I do ?
Welcome to the forums!
Here's a formula that will achieve this using the native Excel function FIND
Assuming that the cell you are checking is A1
Code:=FIND("Jolie",A1,1)<>0
Lookup the "Find" function in Excel, or "InStr" in VBA (Visual Basic Editor).
Beat you to it :p