How do I remove unwnanted digit in the cell

[jeffwongarrow]

Dear All

I am trying to working on some data preparation as below, so that I could work on a countif function to identify any duplicate, however the original 2 sets of data had different format of the ID number, wondering is there anyway to solve this issue.

As below the ID contains "000", "00", "0" in some ID, but in excel logic it still able to perform the countif regardless there are extra digit at the beginning, in Alteryx I believe I have to clear those"000", appreciate your help. thank you

Company A	8170353
Company A	0008170353
Company B	99322370
Company B	009322370
Company C	109503349
Company C	0109503349
Company D	8171160
Company D	0008171160
Company E	4838410
Company E	0004838410

[Qiu · Accepted solution]

@jeffwongarrow 
Hope this is what you need.

Appreciate you would mark it as accept if you find it useful.

[jeffwongarrow]

this is working perfectly, thanks a lot.

[Qiu]

@jeffwongarrow 
Thank you for the mark also.