Need a hand? We've got you covered.

Knowledge Base Home aero-right General questions aero-right How do I remove line breaks in my Excel file?

How do I remove line breaks in my Excel file?

General questions Updated on August 11, 2011
If you have a list of contacts in your Excel file with the first and last name appearing on two separate lines (example below), you’ll want to edit the file so that the first and last name all appear on one line, removing the line break from the cells.

Here is an example of how your list may look:

To remove the line break between the first and last name, and have the name appear on one line (ex. Your Name), follow these steps:

  1. Open the Find/Replace command window.
  2. Place your cursor in the Find what box. Press and hold the Alt key and then enter "010" from the 10-keypad portion of your keyboard. (Note: The numbers from the top row of the keyboard will not work.) If "010" does not work, try "013", as data imported from another source may have the line breaks represented by a different code.
  3. Place your cursor in the Replace with box. Press your space bar once. This will replace the line break with a space so that the name will appear this way: John Smith. If you leave this blank, the name may look like this: JohnSmith.
  4. Click Replace All.
Did this answer your questions?
10 15

Can't find what you're looking for?

Submit a Ticket

view ticket history