Trim and Substitute ' | Airtable Community

I am working on a formula that

1. Trims

2. Replaces Double Quotes (") with Apostrophes Quote (')

3. Replaces Ampersands (&) with 'and'.

TRIM(SUBSTITUTE(
SUBSTITUTE(DESCRIPTION, '"', ''),'&','and'))

The above works, except, if I change it to include the Apostrophes Quote ('), it gets an airtable error. Any advice?

Kevin

Page 1 / 1

Try this:

TRIM(

  SUBSTITUTE(

    SUBSTITUTE(

      Description, 

      '"', 

      "'"

    ),

    '&',

    'and'

  )

)

Sign up