This macro loops through an individual column to trim spaces on the left and right of your data.

  1. Open your macros workbook.
  2. Download this code.
  3. In Excel> Go to Visual Basic Editor> File import this code.
  4. Open workbook to cleanse> Select column range with data> View tab> Macros> View Macros> Run> wait for completedmessage box. done.

Made by Jason, Chris and Shawn

© 2020 Builtneat, Inc. All rights reserved.