1. Home
  2. Knowledge Base
  3. Microsoft
  4. Excel
  5. Remove line breaks from Excel

Remove line breaks from Excel

Example: Line breaks have been created in individual cells of an Excel spreadsheet.

If you want to delete them again, you have to remove them all manually.

Solution : the line break can be removed with the ” Find and Replace ”  function .

A 2 The HTML code for a space is as follows:  : A text without line breaks

A 4  : A text with line breaks

A 7  : A supposedly empty cell – but it contains line breaks.

Press – ” Start”

Then “ Search and select”  (magnifying glass symbol) then open the “ Replace ” submenu .

In the Find What field   , 1  press and hold the Alt key while typing 010 on the ( important! ) numeric keypad. Then release the Alt key. You won’t see a character in the field now, but it’s definitely there. The contents of the Replace With field  2  depends on what you want. If you want the superfluous breaks to disappear without replacement, leave the field empty. If you want (also invisible) spaces instead, press the space once in the “ Replace with ”  2  field. After clicking on “ Replace all ”   3  the breaks disappear.

“OK”  4    Press. In this example, 8 digits have been changed.

Dieser Beitrag ist auch verfügbar auf: Deutsch (German)

Was this article helpful?

Related Articles

Submit a Comment

Your email address will not be published. Required fields are marked *

Published on - 3. Mar 2023
Modified on - 27. Mar 2024
Views - 152
Likes - 0

Do you need help?

Kontaktiere uns gerne :-)
Contact Support
Skip to content