Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am aware of how to add text to an expression as so:
=IF((Year)< 1935,'Dont care','Do care'))
However I am struggling to add an apostrophe to the word "don't" in my expression.
Your advice is much appreciate
=IF((year)< 1935,'Don'&Chr(39)&'t care','Do care')
=IF((year)< 1935,'Don'&Chr(39)&'t care','Do care')
Hi Frank
Works a treat. Thank you.
Regards
Ellis