When you use a field to link from Word to Excel, you get all of the data in the Excel cell. Evidently some of your Excel cells have extra white space in them. The link fields cannot remove that and Word doesn't have a TRIM field that could do the job. Consequently, you need to fix the issue at its source (i.e. in Excel).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|