Remove Specific First and Last Unwanted Character

[GAD318]

I have a list of names where a handful of names has a ' (ie. quote mark) as the first and last character that needs to be removed. I tried the formula, remove first and last character but that of course will remove the first character of names with the correct format. I cannot use a formula to remove the ' because some people (see example) actually have the quote mark character in their name.

I need a formula to remove the quote mark only if the name begins and ends with it. Can someone help me with this? Sorry if it is an easy solution but I'm just a beginner! 

[OllieClarke · Accepted solution]

Hey @GAD318 try this:

TRIM([Full Name],"'")

Which should remove a singe quote from the beginning and end of the name

Hope that helps,

Ollie

[GAD318]

That worked! Thanks so much Ollie.