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

Hello!

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!

Meredith

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!