Clean up text
Remove line breaks from a cell
=SUBSTITUTE(A2,CHAR(10)," ")How it works in Excel
- CHAR(10) is the hidden line break character.
- " " replaces each one with a space.
- CLEAN removes line breaks and other hidden characters too.
The idea in general
A line break is just a hidden character, so it can be swapped out.
What I assumed
- The text is in A2.
Check the result on your own data before relying on it.