FWIW, I think the leading spaces is normal behaviour with Excel content pasted into Word depending on the cell formatting applied in Excel.

How are you finding the leading spaces to remove them? A quick fix to remove leading spaces is to centre-align so you could kill two birds with the one stone if you wanted by following that with a right-align.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks, I will try those methods and see how well they work.