
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 23, 2020 12:08 PM
Hello everyone! Ive exhausted all my options. Hopefully the amazing Airtable Community can help me out…
So in essence the formula needs to get words from Column A and separate them with a vertical bar i.e. " | " and if a set of words like “New This Month” exists in column A the spaces need to be replaced by underscores.
In column A (Multiple Select) I have e.g:
Movie, New This Month, Entertainment
I need for column B (Formula) to produce the following with the data in column A e.g:
Movie | New_This_Month | Entertainment
Thank you in advance!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 23, 2020 12:17 PM
This should do the trick @Carlos_Hurtado.
SUBSTITUTE(SUBSTITUTE({Column A}, " ", "_"), ",_", " | ")
The first substitution replaces any blank spaces with underscores, and the second replaces instances of ,_
(an affect of the first substitution) with vertical pipes. This will work with any number of multiple select options.
Let me know if that helps!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 23, 2020 12:17 PM
This should do the trick @Carlos_Hurtado.
SUBSTITUTE(SUBSTITUTE({Column A}, " ", "_"), ",_", " | ")
The first substitution replaces any blank spaces with underscores, and the second replaces instances of ,_
(an affect of the first substitution) with vertical pipes. This will work with any number of multiple select options.
Let me know if that helps!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 23, 2020 12:20 PM
Brilliant Jason! I cant thank you enough!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 23, 2020 12:21 PM
Glad I could help Carlos!
