Thread
:
How do I use an If= statement with an apostrophe (IF(s4="jack's",.
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Vasant Nanavati
external usenet poster
Posts: 1,080
How do I use an If= statement with an apostrophe (IF(s4="jack's",.
It works for me.
__________________________________________________ ______________________
"Denver Tiffany" <Denver
wrote in message
...
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 Quote
Vasant Nanavati
View Public Profile
Find all posts by Vasant Nanavati