I have to put a condition on text which itself contains a single quote. IF(column='Text's',true,false). How do I accomplish that? I tried enclosing single quote with double quote, but it did not work. Any idea?
Try it with the a
Try it with the ascii value for a single quote:
if (column= 'text' & chr(39) & 's', true, false)
Retrieving data ...