Inline breaks in Excel

Sometimes you may get a formatting error from Termsoup when uploading your Excel. This notification may look something like this:

"There are issues with Excel formatting."

If this happens to you, don’t fret! In most cases, this is due to inline breaks within the cells. You can fix this easily by making sure that there are no breaks within the cells of your Excel.

Inline breaks in Excel

----------
----------
Remove inline breaks

- 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.



----------
----------
More ways to remove inline breaks
There are more ways to remove line breaks in Excel. Watch tutorial here.
Was this article helpful?
Cancel
Thank you!