Hi Pete,

Try this:

=TRIM(A1)

Regards,
KL


"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?