ExcelVBATrimSpacesFromColumn

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.