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!