How do I delete last two digits without going in each cell-Excel
 

Is there a formula for deleting the first or last digits in a cell without
having to manually go into each one? I am sure there used to be a formula in
an earlier version!

Thanks

How do I delete last two digits without going in each cell-Excel
 

This removes the last

=IF(A1=10,--LEFT(A1,LEN(A1)-1),"")

this the first

=IF(A3=10,--MID(A3,2,99),"")

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Speedy!!" wrote in message
...
Is there a formula for deleting the first or last digits in a cell without
having to manually go into each one? I am sure there used to be a formula
in
an earlier version!

Thanks