There are easier ways to do this cleanup. The spaces appear automagically when Excel cells are right aligned and the content is then copied into Word.
Easy non-macro fix is to select table, Centre Align (Ctrl-E) which removes the spaces [Optionally, Left Align (Ctrl-L) if you want to reset alignment but the next step make it superfluous]. Then apply a style (which has the decimal tab already set) to the numbered cells. You could use this same approach in a macro to avoid looping through the cells.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|