Split Data in a Cell

[scotteriley]

Greetings,
I would like to split the data in a cell. I would like to capture only the 9 digits from the far right in a cell. Example below.


Data in Access table cell: A-0072256660S

From the data above, I would like to run a query to retain: 72256660S

Any thoughts? Thanks in advance for your assistance.

 

[sulakvea]

hi, and welcome to MrExcel.

you want it in number or text format?

 

[scotteriley]

TXT format is fine.

 

[Joe4]

Just use the RIGHT function.

MyNewField: RIGHT([FieldName],9)

 

[scotteriley]

Thank you very much!!