Merge inconsistent I use MS Excel and MS Word from Office 2010 to merge a variet
ID: 3561277 • Letter: M
Question
Merge inconsistent
I use MS Excel and MS Word from Office 2010 to merge a variety of documents - Check Requisitions, emails, letters to the recipients. Each sheet row contains the details for one recipient: Name, address, amount., check number... etc.
Regardless of what I do in either the Excel Workbook or the 'receiving' Word document, the merge emerges with a space behind the name in only the first page! The column in Excel is formatted as TEXT, and there is decidedly NO SPACE after the name in the cells.
The results can be seen here. They are snips from the merged document (Victor and Freeman) and of the field syntax.
Why does the merge enter a space inconsistently? Moreover, HOW does it get fixed?
Explanation / Answer
in the paste option, click on "keep source formatting" and use it as default paste option.