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…

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.