Remove extra characters from a cell

[Ann]

This may be something simple, but does any one now how to
remove leading characters from a cell that was imported
from another system. The first 8 characters are zeros and
don't belong in my spreadsheet. Thanks in advance.

 

[Frank Kabel]

Hi
you could enter the following in a helper columne
=MID(A1,9,255)
and copy this down

 

[David McRitchie]

Hi Ann,
If the cell has a non breaking space or even if it is
preceded by a single apostrophe to make it text the TRIMALL
macro will probably work for you
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Normally, I think, with leading zeros you'd want to retain them,
but in this case you don't so it actually works out for you.

 

[Ann]

Frank,
It worked perfect. Thanks a million and Have a super day!