MS Word Mail Merge Formatting Fix


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.

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 ."

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