Removing Line Feeds in Excel

Sometimes when text data is imported from other systems it can contain line feeds.

A line feed wraps the text onto a new line – it is not associated with the Wrap Text format.

Cell A1 below shows an example. Cell B1 has the formula that removes line feeds ans replaces it with a space.

line feed example

The formula in B1 is

=SUBSTITUTE(A1,CHAR(10)," ")