Removing digits from front and back of number in a cell

[Scott]

I have a column of numbers that I need to delete the
first 5 digits of the number and the last 2 digits of the
number. Can this be done in Excel? If so, how?

Any help would be appreciated.

Thank you,
Scott

 

[Kevin Stecyk]

Hi Scott,

Assuming your number is in cell A1

=LEFT(RIGHT(A1,LEN(A1)-5),LEN(A1)-5-2)

Or slightly simplified,

=LEFT(RIGHT(A1,LEN(A1)-5),LEN(A1)-7)

Hope that helps.

Regards,
Kevin

 

[David Hager]

=VALUE(MID(A1,6,LEN(A1)-7))