MS Access

[Afern]

Below are 3 lines of sample data contained in one field. In MS Access, how do i extract for example the 70011858 from the string of text.

000000032404 0070011585
4/2/04 STMT 0070011713
000000000146 0070011816
0404-129 0070011807

thx

[hspc]

SELECT right(field1,8) from table1