Remove empty line breaks in excel

If you work with data that is imported from databases or salesforce, you’ve probably already dealt with line breaks.

A line break is something that allows you to have multiple lines in the same cell in Excel.

Below is an example of a name and address dataset wherein a single line, name and different parts of the address are separated by a line break.

While it looks great in the above example, sometimes, you may not want these line breaks and have a need to remove these line breaks from the dataset.

In this tutorial, I will show you three simple ways to remove line breaks in Excel (also called in-cell carriage return in Excel).

Remove Line Breaks Using Find and Replace

The easiest way to remove line breaks manually is by using Find and Replace.

You can easily apply this to a large dataset and Find and Replace will do all the heavy lifting by finding all the line breaks and removing them from the cells.

Suppose you have a dataset of addresses as shown below from which you want to remove the line breaks.

Below are

how to remove line breaks in excel 2016

how to remove line breaks in excel vba