Edit numeric data typed as string

[colling]

Hi everyone

I have one question realated parsing data.

The current column type is string but detailed datas are union of numbers and string.

In this situation, I would like to choose data which is composed only of number and delete zero with formula. 

For example, I want to substitute '00082738' data to '82738' and the others are remained

Before	After
00k228g	00k228g
00082738	82738
ckdkrkk	ckdkrkk

Is there any solution? please share your intelligent idea. ; - ;

Thank you

[binu_acs]

@colling 

Spoiler

[Qiu]

@colling 
A bit different approach

[colling]

@binu_acs @Qiu 

Thank you to your reply, I solved the problem 

I really appreciate your kindness!

Thank you

Have a nice day!

[Qiu]

@colling 
happy to help and would appreciate if you could mark my solution as accept so other person can also refer it.