Remove leading zeros from a ######-##-# format

[Gain]

Hi,

I have a list of values in the following format: ######-##-# (for example: 000115-32-2 or 000050-50-0). Some of the cells in that column have text as well as numeric values. How can I remove the leading zeros, considering there is a different amount of leading zeros for my values?

Thank you in advance

 

[Gain]

This question is also posted here: http://www.ozgrid.com/forum/showthread.php?t=167248

 

[T. Valko]

Hi,

I have a list of values in the following format: ######-##-# (for example: 000115-32-2 or 000050-50-0). Some of the cells in that column have text as well as numeric values. How can I remove the leading zeros, considering there is a different amount of leading zeros for my values?

Thank you in advance

Try this...

Book1
	A	B
2	000115-32-2	115-32-2
3	000050-50-0	50-50-0
Sheet1

This formula entered in B2 and copied down:

=MID(A2,FIND(LEFT(SUBSTITUTE(A2,0,"")),A2),255)

 

[Gain]

This worked, thank you

 

[T. Valko]

This worked, thank you

You're welcome. Thanks for the feedback!