Benchmark Email Help Center

or chat with:

smart support, our Benchmark Email expert powered by AI

chat now

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 September 9, 2019

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.