From B0101 to 101

[Guest]

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.

 

[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!

 

[Guest]

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

 

[Guest]

Thanks 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!

 

[Guest]

Thankyou 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