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