Just a quick note because this helped me a lot 🙂
To replace a linebreak in an excel cell:
In Excel, choose Edit>Replace
Click in the Find What box
Hold the Alt key, and (on the number keypad), type 0010
This represents a line break in Excel.
You won’t see anything in the ‘Find What’ box
In the Replace with box, type the characters that you want to use
instead of a line break
Click the Replace All button
Props go to this thread.
Hope it helps someone else…