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
Best Answer
-
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
Answers
-
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
-
Thank you @Linda Manduchova! I can work with this.
Help Article Resources
Categories
Check out the Formula Handbook template!