The formulas below are much flexible. They will work with a word name Jack.
Example: "Jack ", " jack ", "Jack's", "Hello Jack", and so on....

=IF(ISNUMBER(SEARCH("Jack",A1)),1,"")
or
=IF(COUNTIF(A1,"*Jack*"),1,"")


"Denver Tiffany" wrote:

I need to set a new cell's value to a numeric digit by saying :
If(s4="Jack's", 1, ""). But it won't work b/c of the apostrophe inside of
"Jack's".

Is there a way around this without altering the data?