Greetings,
I'm doing a Mail Merge in Word with Excel as the de facto database. If I start an Excel cell with a space, the Mail Merge blows it away like it was never there. All that survives the Mail Merge are the remaining characters after the space. I've learned that
I can use an underscore as a space keeper instead. Is there an alternative to the underscore as a space-keeping first character in an Excel cell, please?
Alvis6
This behaviour is by design and AFAIK you can't change it. If the need is to insert one or more spaces before the mergefield when it has data, but not otherwise, you can achieve that by adding a formatting switch to the field. For example, assume there's a «MiddleName» mergefield. Click on this and you should see:
{ MERGEFIELD MiddleName }
Add a \b switch to this with however many spaces (and/or other characters) you need, thus:
{ MERGEFIELD MiddleName \b " " } (for two spaces)
There is also \f switch for adding conditional content after the field.
Paul Edstein
(Fmr MS MVP - Word)
Report abuse
Details (required):
Thank you.
Reported content has been submitted
12 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.