Add the TRIM function to my macro

[murp5972]

Hi,
I've got a macro that consolidates all of the data within every sheet of a workbook, and copies it into a "combined" sheet within the workbook. As you can see it also does a couple of adjustments to make the data more presentable. However, I want to add one last step to the code. I want the final step of the code to TRIM all of the text within column A, I'm hoping I can have it be trimmed of extra spaces and still remain within column A. I'm not sure how to type this in code. Any help is greatly appreciated!! Thanks! Heres the code:

Please Login or Register  to view this content.

[quekbc]

You can add, at the end of your code,

Please Login or Register  to view this content.