Link to home
Start Free TrialLog in
Avatar of penguins_rule
penguins_ruleFlag for United States of America

asked on

keep leading spaces in Mail Merge Word 2013

I have a tab delimited file. Some of the fields have leading spaces. When I use Mail Merge in Word 2013, the leading spaces are missing.
I tried a comma separated file where each field has quotes. Mail merge could not figure out the delimiter. I tried using quote and then tried comma.
ASKER CERTIFIED SOLUTION
Avatar of Theo Kouwenhoven
Theo Kouwenhoven
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
BTW the non-breakable-space is an Ascii hex (A0) character
Avatar of penguins_rule

ASKER

i'm not sure i can get the non-breakable-space in the original file since it is usually cannot contain non-printable characters except tab, newline, and carriage return.

Is there a way to do it if i cannot embed the non-breakable-space?
Can't you replace the leading spaces by a tab character?
If the inputfile is in xml format, the   character is a valid value

(To process xml data in word you have to make a xsd)
appreciate your help. I ended up doing the project a different way other than mail merge.