Single Quote in Editor

[Anonymous]

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?

Thanks,

Dinesh.

[#2]

Try it with the a

[#3 · Accepted solution]

Try it with the ascii value for a single quote:

if (column= 'text' & chr(39) & 's', true, false)

Regards,

Gordon