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’ boxIn the Replace with box, type the characters that you want to use
instead of a line breakClick the Replace All button
Props go to this thread.
Hope it helps someone else…