View Single Post
 
Old 03-15-2022, 03:51 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote