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

Meredith Rhodes

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

Linda Manduchova

Hello @Meredith Rhodes -

You can try the following formula, however, if you have multiple line-breaks, the formula will return multiple semicolons.

=SUBSTITUTE(Name@row, CHAR(10), "; ")

Linda

Linda Manduchova

Hello @Meredith Rhodes -

You can try the following formula, however, if you have multiple line-breaks, the formula will return multiple semicolons.

=SUBSTITUTE(Name@row, CHAR(10), "; ")

Linda

Meredith Rhodes

Thank you @Linda Manduchova! I can work with this.