Remove spaces when concatenated field is blank [Field]@2row + " "

Scottd

When using Join or concatenating via the + sign I am adding a space after each field. Sometimes not all 8 fields have a value but the space is still entered for blank fields. It looks good in smart sheet, but when you go to export it is has a space for each blank field. I would like to remove the extra spaces so when exported it can be used with no editing.

Hollie Green

I would use a JOIN(COLLECT formula and exclude the blank fields

Hollie Green

I would use a JOIN(COLLECT formula and exclude the blank fields

Scottd

Thanks Hollie that was a great suggestion.