This macro loops through an individual column to trim spaces on the left and right of your data.
Open your macros workbook. Download this code. In Excel> Go to Visual Basic Editor> File import this code. Open workbook to cleanse> Select column range with data> View tab> Macros> View Macros> Run> wait for completedmessage box. done.