From B0101 to 101

S

Steved

Hello from Steved

How do I please write a formula that will delete the first digits as for
example delete the B0 from B0101 to leave 101

Thankyou.
 
D

Domenic

If you always want to delete the first two digits, try...

=RIGHT(A2,LEN(A2)-2)

or

=MID(A2,3,1024)

Hope this helps!
 
E

Elkar

Will it always be just the first 2 digits you're removing? If so, then try
this:

=MID(A1,3,LEN(A1)-2)

HTH,
Elkar
 
Top