Remove leading & trailing number

Dave · Oct 5, 2004

Hi
Is their way to use a formula to remove the first leading
number and also the last trailing number in a cell?

Thanks
Dave

Frank Kabel · Oct 5, 2004

Hi
do you mean
=MID(A1,2,LEN(A1)-2)