How to Extract an Apostrophe ' from text

[Stefan_QREW]

When trying to remove an apostrophe from this text:

[Dimensions] = "100'"

using this formula

SUBSTITUTE([Dimensions], "'", "")

I get this error: UNTERMINATED STRING

Is there a way for appsheet to not interpret the ’ as a single quote? An escape character or something?

Another oddity, If I add a space after the apostrophe, then it clears the error. Very curious behavior???

SUBSTITUTE([Dimensions], "' ", "")