Quote Originally Posted by TMS View Post
Not sure what your problem is with TRIM

Formula: copy to clipboard 
=TRIM(A2)
copied down will remove excess spaces, and leading and trailing spaces
I am looking for VBA as I am doing some automation on it. Can I use trim to the whole column? or trim cell by cell till last row?

Thanks