Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1361 2
cancel
Showing results for 
Search instead for 
Did you mean: 
shelby_jackson
4 - Data Explorer
4 - Data Explorer

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
kuovonne
18 - Pluto
18 - Pluto

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto
shelby_jackson
4 - Data Explorer
4 - Data Explorer

Thank you so much, @kuovonne! :heart_eyes: