Using Single Select Column data to make a Multiple...

[Carlos_Hurtado]

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!

[Jason · Accepted solution]

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!

[Carlos_Hurtado]

Jason:

SUBSTITUTE(SUBSTITUTE({Column A}, " ", “"), ",”, " | ")

Brilliant Jason! I cant thank you enough!

[Jason]

Glad I could help Carlos!