Transform multiple lines in a single field into separate new lines


Hi, I have a requirement where in multiple lines in a single field has to be transformed to different lines one after the other in the same field.

The below picture would illustrate what is currently and what is expected. Any thoughts that you can share would be much appreciated.

Best Answer

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Answer ✓

    Not that I have ever seen. Its only going to pull in the text the way it is. If you can structure you data to be the way you want it to look in your cell, that may be the only way to do it.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!