strip off leading zeros

[Jeffrey Green]

[TABLE="width: 203"]
<tbody>[TR]
[TD="class: xl65, width: 203"]00080236528-GP0KA

I need the leading zeros to go away.
leaving me with
[TABLE="width: 203"]
<tbody>[TR]
[TD="class: xl65, width: 203"]80236528-GP0KA

thanks[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Note, there are varying numbers of 0s' and the length of the string isnt the same all the time.

 

[Tetra201]

@ jtakw:

Your solution would work only if Joe4's assumption (Post # 2) is correct, which may/may not be the case.

 

[jtakw]

That's also my assumption...

 

[wideboydixon]

New solution:

Book1
	A	B
1	00080236528-GP0KA	80236528-GP0KA
Sheet1

Cell Formulas
Range	Formula
B1	=MID($A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9},$A1&"0123456789")),LEN($A1))

WBD