What is the formula in getting the middle numbers in a set of numbers in microsoft excel?

Question

FOR EXAMPLE THIS NUMBER. 020023. How do I get the middle numbers using microsoft excel?

Answer 1

What do you meen by middle numbers?
If you want to get the 00 from 020023, then use MID function like this
=MID( A1, 3,2)
assuming you want to get the middle text, starting from the 3rd charactor and for 2 charactors long
There are other several ways to do it, but i don't understand what is exaactly what you want

Enjoy my profile, I am the VBAXLMan

Answer 2

One way is to use the TEXT function, to convert the numbers to text, the use the MID to extract from the middle.