What is line break

Line break is the end of a line of text. In Excel, it looks like this:

Inline breaks in Excel

----------

How line break affect data import

Sometimes you may get a formatting error on Termsoup when importing an Excel data. This notification may look something like this:

"There are issues with Excel formatting."

----------

Remove line break

- Open the Find & Replace box, or you can press "Ctrl+h" to open it.
- In the Find What cell, press Ctrl+J (a dot will appear).
- In the Replace With box, type a space.
- Click on Replace All, and the inline breaks will be replaced with a single space.



----------

Other ways to remove line break

There are other ways to remove line breaks in Excel.

Was this article helpful?
Cancel
Thank you!