From B0101 to 101
 

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.

From B0101 to 101
 

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

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

or

=MID(A2,3,1024)

Hope this helps!

In article ,
Steved wrote:

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.

From B0101 to 101
 

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


"Steved" wrote:

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.

From B0101 to 101
 

Thanks Domenic.

"Domenic" wrote:

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

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

or

=MID(A2,3,1024)

Hope this helps!

In article ,
Steved wrote:

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.

From B0101 to 101
 

Thankyou Elkar

"Elkar" wrote:

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


"Steved" wrote:

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.