I don't know how to prevent this happening but you might be able to fix it to some degree in Excel by using Find & Replace (CRTL+H) and then in the Find box pressing CTRL+J, and placing a SPACE BAR into the Replace box or try leaving it blank. Slightly more info below and at this URL:
- Press Ctrl+H from the keyboard. As a result, the Find and Replace window will pop up. Now, go to the Find what field and press Ctrl+J. A dot (.) will show up in the box. Keep Replace with field blank. Finally, click the Replace All button.
