The apostrophe does not cause a problem in this formula. Since it is in
between the two double-quotes, it will be read as part of the text string.

Does your data in S4 include the quotes? If so, that is where the problem
lies. Try writing your formula like this instead:

=IF(S4="""Jack's""",1,"")

HTH,
Elkar


"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?