Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Concatenate fields with comma, except when fields are empty

Topic Labels: Formulas
1695 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello, I am trying to concatenate 4 fields into one field with commas in between each field, only when the fields have a value in them (ie. no comma for empty fields). I’m using the below formula successfully to combine 2 fields, excluding the comma when a field is blank. But, I don’t know how to lengthen this formula to cover 4 fields. My 4 fields are, “Building,” “City,” “State,” & “Country.” I’ve tried several variations and can’t figure this out.

=IF(OR(Building=BLANK(),City=BLANK()),CONCATENATE(Building,City),CONCATENATE(Building,", ",City))

Thank you for any help you can provide!

1 Reply 1

Answered in this other thread.