MS Word Mail Merge Formatting Fix

MS Word Mail Merge Formatting Fix

Closed - This job posting has been filled and work has been completed.

Job Description

We have a MS Word mail merge file that pulls data from MS Excel.

Excel adds an extra space after numbers it sends.

Example:
Excel data has number "5,432" that gets merged into document. The item gets passed as "5,432 " such that in a sentence it appears "the amount of 5,432 ."

Requirement:
We require a macro / vba script to remove the trailing space ONLY on the data fields.