MS Word Mail Merge Formatting Fix
Closed - This job posting has been filled and work has been completed.
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.