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

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!


Thank you so much, @kuovonne! :heart_eyes:

1 Like

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