Removing Leading Spaces in a column of data with VBA Code

I thought I solved this once before but I cannot find it in my past posts. It should be pretty simple.

I have a column of data in column B. The column contains both numbers and text. The contents comes from an XML file that is converted to a worksheet. The has a random number of rows. For some reason the content has spaces in front of the contents. I need those leading spaces removed. Does anyone know a simple set of instructions in VBA code that can go through that column and remove those leading spaces?

Thanks in advance!

You can use an adjacent column with the TRIM formula, copy down. Copy as value to their original column. Or write VBA code to do same (but it really is quite fast to use Trim copy then paste values

Originally Posted by Mumps1

Try:

Please Login or Register  to view this content.

Thanks Mumps1 your code works great!!