How to detect leading or trailing apostrophe and quote characters

Thanks,
I'll try the formulae you've suggested. Would you be able to explain the logic behind the forlmulae as I'm not familair with these functions or the use of curly brackets.