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.
|