Only remove first digit if it is a "0"

[Steved]

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

 

[Steved]

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]

Hello from Steved

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

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

Thankyou.

 

[Rick Rothstein]

Assuming the "0" is actually part of the cell's value and not put there by
Cell Formatting, then try this formula...

=MID(B1,1+(LEFT(B1)="0"),99)

and copy it down as needed.

 

[Steved]

Hello Rick

I Thankyou

Steved

Assuming the "0" is actually part of the cell's value and not put there by
Cell Formatting, then try this formula...

=MID(B1,1+(LEFT(B1)="0"),99)

and copy it down as needed.