Concatenate with ' in string

[Simon1]

I'm trying to concatenate a few fields and some text.

[Width for Description]&"mm '"&[Range]&"' "&[Finish Name]

But this has an error 

Expression '[Width for Description]&"mm '"&[Range]&"' "&[Finish Name]' was unable to be parsed: Unterminated string.

When I change it to [Width for Description]&"mm ' "&[Range]&"' "&[Finish Name] with a space after the ' it is ok.

I tried CONCATENATE([Width........ but that gave the same error.

Is there any way I can have ' with no space and then [Range] after it?

I tried putting it inside TEXT("mm '"), but that doesn't work either. It says number of parentheses don't match, but if I put the space back in it's ok.

[Aurelien · Accepted solution]

Can you try:

CONCATENATE([Width for Description],"mm ",LEFT("’ “, 1),[Range],LEFT("’ “, 1), " ",[Finish Name])

Based on this:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/How-to-Extract-an-Apostrophe-from-text/m-p/2681... 

[Simon1]

Thanks. That worked.

Should have searched harder.

I think I forgot what an apostrophe was called 🙂

[Aurelien]

Well actually, I'm French : quotation marks are named "apostrophe" here... it was easier for me to look for it hahaha