ASAP Utilities, a free add-in at www.asap-utilities.com includes this
capability among it's many nifty features.........

Vaya con Dios,
Chuck, CABGx3


"Pete" wrote in message
...
I need a formula to remove/delete leading spaces from a cell.

column b contains data imported from anothe application. unfortuantly some
of these cells have padded leading blanks added.

I need to remove these. but 3000+ cells individually will take hours.

any help?