Hello from Steve Dee

Please I would like to only remove first digit if it is a "0" In Col B:B.

Yes their are more digits in a row in Col B:B

Yes some have digit starting at "1" to "9" which I need to stay

Yes their is 1 Character only "X" which I need to stay

I thankyou