Thread: How do I use an If= statement with an apostrophe (IF(s4="jack's",.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Denver Tiffany Denver Tiffany is offline
external usenet poster
  
Posts: 1
Default How do I use an If= statement with an apostrophe (IF(s4="jack's",.
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?
Reply With QuoteReply With Quote