get SSNs from text and other numbers

[lgirl]

I have a cell that contains text, phone numbers with hyphens, and SSN numbers with hyphens.

I only want to get the SSN.

I am using a the formula =MID(B10,SEARCH("-",B10,1)-3,11 but it pulls in the phone number or any other number that has a hyphen if they are before the SSN number.

Is there a formula I can use to pull in only the SSN?

 

[Jonmo1]

Can you post a few sample sets of data
Changing real names and SSNs to fake ones 123-45-6789

 

[lgirl]

cell a1 would contain the text:
The phone number 456-123-4567 is part of the number 123-45-6789 (fictitious ssn number) test test test

cell a2 would contain the text:
12-11-1999 The phone number 123-123-4444 is part of the number 123-44-4444 (fictitious ssn number) test test test

The lines above are samples. I would like to get the fictitious ssn numbers above only.

 

[Jonmo1]

Perhaps

=MID(A1,SEARCH("???-??-????",A1),11)

 

[lgirl]

That works wonderful!!

I have been trying to do this for a couple of days and you have been able to help me in a matter of a few minutes.

Thank you so much!

 

[Jonmo1]

Glad to help, thanks for the feedback.

 

[NiceGuyRitchie]

Have you considered using Excel's 'Text to Columns' approach? It's non-formulaic but it parses out text very clean if data format is consistent.

Ah, did not see prior helpful post. Very cool solution!