Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Convert a List of Words SemiColon Separated to Comma

posted Jan 16, 2018 11:37:22 AM

Topic Labels: Formulas

0 1236 1

I want to convert a list of words separated by semicolons in one column to a list of words separated my commas in another column.

Any Ideas on how to do this in Airtable?

1 Reply 1

Found this works:

=SUBSTITUTE({Column Name}, “;”, “,”)