Hard space

[Diane]

My data to be merged into a Word document is an Excel
file. I want to be able to put hard spaces in character
fields so that data does not wrap once the merge is done.
If I insert an hard space in my Excel field, the hard
space disappears once merged. Any idea?

 

[Cindy Meister -WordMVP-]

Hi Diane,

My data to be merged into a Word document is an Excel
file. I want to be able to put hard spaces in character
fields so that data does not wrap once the merge is done.
If I insert an hard space in my Excel field, the hard
space disappears once merged. Any idea?

Tricky... I'm not sure this can done at all with mail merge.

What character code do you use in Excel to insert a
non-breaking space?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail