Gary points out that the TRIM Function in VBA isn't working like =TRIM() Function in the worksheet; the spaces in the middle remain after a Macro run. Bill shows us, In episode #1465, how to solve this issue with the 'Application.WorksheetFunction'.