formula to drop first first 2 digits and last one

[CRAIG20]

Hi

Cell A2 contains the following text:

="7083176237106797"

I would like a formula that will drop the first 2 digits (=") and also the last (")

Many thanks

Craig

 

[Peter_SSs]

If they are all 16 digits long
=MID(A1,3,13)

Otherwise
=MID(A1,3,LEN(A1)-3)

 

[Peter_SSs]

I might have misinterpreted your question. Perhaps you meant drop the first 2 and last "characters" rather than "digits". If that is the case, my first formula should have been
=MID(A1,3,16)

Second formula would be unchanged.

 

[CRAIG20]

perfect. thank you.

 

[Peter_SSs]

perfect. thank you.

You are very welcome.