strip off leading zeros

[Jeffrey Green]

00080236528-GP0KA I need the leading zeros to go away. leaving me with 80236528-GP0KA thanks <tbody> </tbody>

<tbody>
</tbody>

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