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!
