Help

Trim and Substitute '

Topic Labels: Formulas
185 1
cancel
Showing results for 
Search instead for 
Did you mean: 
K_B1
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
TheTimeSavingCo
17 - Neptune
17 - Neptune

Try this:

 

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

Screenshot 2024-02-27 at 10.25.04 AM.png