If you want to right-align all these texts you would probably be better off
putting a right-aligned tab in Word immediately before the appropriate merge
field.
[Otherwise, unfortunately all the connection methods that Word can use to
get data from Excel strip off both leading and trailing blanks, except the
Excel converter, which is no longer provided with Word (since version 2002
or 2003, I forget which) or in the add-on converter pack. If you really
want, I think you can get a copy of the converter from Graham Mayor's
download page at
http://www.gmayor.com/downloads.htm . Be aware that the
converter has been withdrawn for a reason, has not been maintained for some
time, and will always pop up a dialog whenever you connect using it]
Peter Jamieson
"ksg" wrote in message
...
I have an automated mail merge program that accepts data from different
systems. The data is in an Excel Sheet. Some of the data has blanks in
the
data. The data would look something like this:
" DataField1"
" DataFields2"
etc.
I need to keep the leading blanks so the data will line up on the merged
document.
I have tried enclosing the data in "" in the Excel Cell. This keeps the
blanks, but the quotes print out on the document.
Any help would be appreciated.
Thanks