Hello from Steved

Oops I forgot to check my column, the below does not remove the first "0"

=MID(B35,1,LEN(B35))

Thankyou.



"Steved" wrote:

Hello from Steved

I looked at other answers to my query

=MID(B35,1,LEN(B35))

Thankyou.

ps Can the above be done in VBA please.



"Steved" wrote:

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