remove leading space in cell?

[djarcadian]

I exported some data from Quickbooks and for some reason it put a leading space in some of the cells. Is there a way to remove just this leading space?

[ChemistB]

In the next column

Please Login or Register  to view this content.

assuming your value is in A1, then drag down. Copy and paste values over the original data to make it permanent.

Does this work?

ChemistB

[djarcadian]

Thanks! That worked.