How to extract numbers out of a text string

[fewaldron]

Hello,

I have a text string that contains a social secuirty number and I want to extract it to a different column. Example:

Text string: D4AX3TY05T123456789T
I am trying to extract the SSN (underlined) and place it in a separate column. One thing about this text string is that the SSN starts at the 11th character and they all have a T at the end. Any help is appreciated.

fewaldron

 

[alansidman]

Excel Workbook
	B	C
2	D4AX3TY05T123456789T	123456789
Sheet3

 

[fewaldron]

Thank you for your quick response...I have no idea why I was trying to use the MID, LEFT and FIND functions...

that's why they always say K.I.S.S.

Thanks again...