Frequently Asked Questions
was designed with your needs in mind. So, there is a good chance that you will find the answer to your question here. Plus, it is available to you 24 hours a day, 7 days a week.
Select a topic to start
Search by Topic
How do I remove line breaks in my Excel file?
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:
- Open the Find/Replace command window.
- 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.
- 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.
- Click Replace All.
More related questions