Remove Leading "0" on Serial#'s

[holeshot]

How can I remove the Leading Zero on my Serial#'s, I have about 6000 records
I need to Change.

This is an Example of What I have:
05LN03338
05TJ02670
086X00857

This is what i Need them to look like:
5LN03338
5TJ02670
86X00857

I think I need to use a TRIM code, but can't remember how to Configure it.

Thanks in advance for your help!

 

[Pete_UK]

If it is always going to be a single leading zero, then you can enter
this formula in a spare column:

=RIGHT(A1,LEN(A1)-1)

and copy this down for as many items as you have. This assumes the
serial numbers start in A1 - adjust to suit.

Hope this helps.

Pete

 

[Dave Peterson]

Do they all start with just a single leading 0?

If yes, you could use:
=mid(a1,2,255)
(start in the 2nd position for 255 characters)

or even select the column
Data|Text to columns
fixed width and then
draw a line between the 1st and 2nd character
and skip the first field.

 

[holeshot]

Thanks For you Help Dave & Pete.

All three worked Perfect. that was exactly what I was looking for what I was
trying to do.

Thanks Again!!!