Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Leading spaces in Mail Merge field not printing
Hi ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing a full page of labels using Mail Merge fields | Microsoft Word Help | |||
How do I eliminate numerous "Mail Merge..." under my tool bar? | Microsoft Word Help | |||
Mail Merge - Date Format | Microsoft Word Help | |||
How do I mail merge when only merge document is shown in tools? | Microsoft Word Help | |||
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements | Mailmerge |