Concatenate From a Multiple Selection Column

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!
Screen Shot 2020-06-23 at 2.53.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!

Brilliant Jason! I cant thank you enough!

Glad I could help Carlos!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.