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 and replaces it with a space.
The formula in B1 is
=SUBSTITUTE(A1,CHAR(10)," ")