What is line break
Line break is the end of a line of text. In Excel, it looks like this:
----------
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:
----------
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.
Line break is the end of a line of text. In Excel, it looks like this:
----------
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:
----------
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.
Updated on: 09 / 25 / 2021