Converting an Excel document to a Word document | Excel forum

Hello Karen

Thank you for your question and welcome to the forum.

A couple of things you could try:

1. Try copy and paste from Excel into Notepad, then Notepad into Word and see if that helps.

2. If this doesn't help, try copying and pasting into Word, and use the little Paste options button that comes up when you paste to select the option to paste Text only; see if that helps.

3. The third option would involve using Replace in Word to replace all the non-printing characters (line breaks etc) with a space instead. This is a little more involved. You will have to turn on the Show-Hide button in Word (looks like a back-to-front P and lives on your standard toolbar); then find for each of the different strange little symbols that appear between the letters EXCEPT for the symbols that appear as a single dot, copy the symbol, go to Edit - Replace, paste the symbol into the Find what box. Then for Replace with, click into the box and press the spacebar once.

This is designed to replace all the strange little extra lines etc with a single space. I hope this helps.

Kind regards
Amanda