Forum Discussion

Brass Contributor

Apr 13, 2022

Solved

How do I remove the first and last number from a 5-digit number?

So I know if I want to remove the last digit of a 5-digit number, I use the formula: =LEFT(C2,4) C2 being the cell I am affecting. In the case of the number 01234 being in cell C2, my formula would...

excel

Formulas and Functions

Detlef_Lewin
Apr 13, 2022
Danger_SF

=MID(TEXT(C2,"00000"),2,3)

EDIT:
Without any text function.
=MOD(QUOTIENT(C2,10),1,000)

Detlef_Lewin

Silver Contributor

Apr 13, 2022

Danger_SF

=MID(TEXT(C2,"00000"),2,3)

EDIT:

Without any text function.

=MOD(QUOTIENT(C2,10),1,000)

Danger_SF

Brass Contributor

Apr 13, 2022

Thank you!