Can I use the Substitute function to remove a line-break?


I'm having success nesting the substitute function to remove multiple things from a field of text in a cell and replace them with a blank space. I would like to remove line-breaks/enter/return and replace them with a semicolon.

I'd like to turn something like this:

Meredith Rhodes, PhD

Meredith Rhodes, PhD

Into this:

Meredith Rhodes, PhD; Meredith Rhodes, PhD

Is there a way to do this?

Thank you!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!