Remove leading zero from alphanumeric string

[sweetkel23]

I'm having trouble removing leading zeros if any from an alphanumeric string, a mapsco grid

Current Data:
062Z
008P
114A


I would like my output to display as:
62Z
8P
114A

I tried the trim(=TRIM(B2)), but I think it only removes spaces, not zeros. Any help is appreciated.

Thanks,
Kelly

[abousetta]

Maybe try:

=LEFT(A1,LEN(A1)-1)*1&RIGHT(A1,1)

Assuming that there is only one letter at the end of the sequence.

abousetta

[sweetkel23]

works great! thank you so much

[abousetta]

Glad it all worked out.

Good luck.

abousetta