Remove Line Breaks in Excel

Submitted by shawngo on

Scenario: You're pissed off because Excel brought in a bunch of unnecessary line breaks in your cells! Buggers!

Quit your rambling and get to the point!

=SUBSTITUTE(A1,CHAR(10),)

Pasting this function into a cell other than A1 will remove the line breaks from whatever value is in cell A1.

This may have an undesirable effect on cells containing more than one line of text as shown in Fig1.

Substitute Text effect
Fig1.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.