Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Concatenate multiple fields separated by commas without string of commas at end

Topic Labels: Formulas
Jump to Solution
241 2
Showing results for 
Search instead for 
Did you mean: 

Hello! I am currently using the below formula to pull together a list of cities that correspond to a record. I have City 1, City 2, City 3, City 4, City 5, Cities 6 fields. Formula looks like this:

CONCATENATE({BP City 1}, ", ",{BP City 2}, ", ",{BP City 3}, ", ",{BP City 4}, ", ",{BP City 5}, ", ",{BP Cities 6})

My formula works if all 6 fields contain cities although it doesn’t look great if only one city is listed. It ends up looking like this:

Philadelphia, , , , ,

Anyone know how to fix the formula so that the appropriate number of commas appear so there will not be a string of messy commas at the end?

Thank you!

1 Solution

Accepted Solutions

See Solution in Thread

2 Replies 2

Thank you so much, @kuovonne! :heart_eyes: