Leading spaces in Mail Merge field not printing

[Kurt Monroe]

I am using an Excel spreadsheet as my data source.

My problem - if the Excel cell has leading spaces in it (spaces on the
left), they do not carry over to the merge field in the Word document.

Is there something to set or change to stop this? I want the spaces to
carry over to the merge field so they show up in the final document.

Thanks,

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?S3VydCBNb25yb2U=?=,

I am using an Excel spreadsheet as my data source.

My problem - if the Excel cell has leading spaces in it (spaces on the
left), they do not carry over to the merge field in the Word document.

This is standard, and by design. The only data source where leading and
trailing spaces are NOT stripped out is if the data is in a Word table.
You could copy/paste the Excel data into Word, as long as there aren't
more than 63 columns.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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