Excess delimiters using CONCAT expression

Hi Appsheet,
Not very much good with the CONCATENATE expression, a little help would be nice…

I was trying to join different columns using CONCAT expression but is returning excess delimiters when few columns are blank. Any suggestion on the formula? Thanks in advance.

3X_f_9_f93ffffe4ba149175e5f4ae8cc92341e6f1b65f8.png

0 1 159
1 REPLY 1

Put an IF() function expression something like only when the data is available perform Concatenate using ISNOTBLANK() function else take a blank(Space) character.

Top Labels in this Space