Categories
Uncategorized

Replace Linebreak in Excel

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…