Severing LAUS codes

Hi,

I'm working with some Data from the BLS website which I need to cut down to another code form (CBAS). In order to that I need to remove the first five letters (which form an acronym describing the data) and the first two numbers (which represent the FIPS state code) as well as the last number (which indicates the data type).

For example:

LAUMC01107603

with the portions that need to be removed in parentheses

(LAUMC01)10760(3)

would become

10760

I need to do this for a column of these codes which contains about a thousand entries.

Thanks

If they are not the same length
=RIGHT(LEFT(A4,LEN(A4)-1),LEN(A4)-8)

If you need a number rather than text
=RIGHT(LEFT(A4,LEN(A4)-1),LEN(A4)-8)*1


Hope this helps