How do i escape a single quote in alteryx?

I've created an if-then formula to rename some units. however one of the unit names contains an apostrophe and that is causing an error. How do i get around that?

ELSEIF (Contains('4371-The Women's Place', [CurrentUnitName]))
THEN 'The Women's Place'

Error Message

Preparation

Accepted answers

StephenRuhl

If you have a single quote in the string, then use double quotes around the string. Alternatively, if you have a double quote in the string, use single quotes around the string.

All comments

StephenRuhl

If you have a single quote in the string, then use double quotes around the string. Alternatively, if you have a double quote in the string, use single quotes around the string.

db-DCA

What if you have both single and double quotes in a string?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703