How to remove line breaks from Excel

Want to remove a line break in Excel? Follow the steps below!

  1. In Excel, choose Edit>Replace
  2. Click the “Find what” box
  3. 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
  4. In the “Replace with” box, type the characters that you want to use instead of a line break
  5. Click the “Replace All” button.

Voila!

This entry was posted in Functions, General tips. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*