Experts- Please assist with the following.
Request: I need a VBA (Trim Function) Code that can loop through five Excel 2007 worksheets while removing all leading/trailing spaces.
a) My dataset range spans from Column A through Column M with a variable number of rows
b) These spaces are created by pasting data from a web page.
c) There are no spaces between text in cells.