How to Prevent Zeros and Unwanted Text in a Formula Output?

System

This discussion was created from comments split from: Join/Collect Multiple Columns to One Cell WITH Column Name.

EJ13

https://community.smartsheet.com/discussion/comment/351333#Comment_351333

When I use this equation, each it has a zero inserted at the beginning.

Also, is there a way to say if the cell is blank not to still put in the "First Column: "?

Paul Newcome

Try this instead:

=IF([FIrst Column]@row <> "", "FIrst Column: " + [First Column]@row + CHAR(10), "") + IF([Second Column]@row <> "", "Second Column: " + [Second Column]@row + CHAR(10), "") + IF([Third Column]@row <> "", "Third Column: " + [Third Column]@row + CHAR(10), "") + ..................................

Genevieve P.

Hi @EJ13

Just checking in to make sure you saw Paul's response above! Did this resolve your formula?