Originally Posted by macropod

When I paste an Excel range containing both text numeric data into Word, the data retain the same formatting and alignments they had in Excel and there are no leading/trailing spaces. In this regard, I note the OP is just using an ordinary Paste, not Word's PasteExcelTable or PasteAndFormat methods, for example.