Used JOIN and SUBSTITUTE to combine data in a row. Now line spacing issue

KoreyG ✭✭
edited 01/05/24 in Formulas and Functions


I have used JOIN and SUBSTITUTE to see which formula works better to combine data from a a row to a single cell. I inserted a HELPER command so that each data is on it's own line. The data is pulled correctly, however there are massive spaces between each line (see screenshot).

Does anyone have/know a way to get rid of those spaces? I'm assuming they are there to represent the columns that do not have data entered between each piece of data.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!