Hello,
I'm trying to pull a specific 10 digit number from a text string. The ID # is always 10 digits however sometimes there are dates in the data that need to be excluded as well as other numbers such as "I-9". The 10 digit number will always start with 1 or 8. Is there a macro or Formula to extract this data? Please find the example dataset below. Thanks in advance!
Edit: I should specify I want the "100118416" number from the first cell example or the "800011320" number from the 10th example. Thanks again.
<TBODY>
</TBODY>
I'm trying to pull a specific 10 digit number from a text string. The ID # is always 10 digits however sometimes there are dates in the data that need to be excluded as well as other numbers such as "I-9". The 10 digit number will always start with 1 or 8. Is there a macro or Formula to extract this data? Please find the example dataset below. Thanks in advance!
Edit: I should specify I want the "100118416" number from the first cell example or the "800011320" number from the 10th example. Thanks again.
NDM Abxx, Kexxxxx 100118416 2-29-12.pdf</SPAN> |
VPG I9 Aberxxxxx, Dexxx 100113048 1-1-12.pdf</SPAN> |
I-9 Abxxx, Rexx 100119966 4-5-12.pdf</SPAN> |
NDM I9 Achxxxn, Paxx 100119008 3-15-2012.pdf</SPAN> |
VPG I-9 Acxxxxx, Toxx 100112782 01-01-12.pdf</SPAN> |
I-9 Acxxxr, Gxxx 100117854 2-27-12.pdf</SPAN> |
NDM Acxxx, Angxxxxx 1001118015 3.3.12.pdf</SPAN> |
ADXXX, DEXXX 100118892 I9.pdf</SPAN> |
I-9 Adxxx, Chxxxxxxx 100119633 3-28-12.pdf</SPAN> |
I-9 Adxxxx, Daxxx 800011320 6-14-12.pdf</SPAN> |
I-9 Adxxxx,Jenxxxx 100121079 5 25 2012.pdf</SPAN> |
VPG I9 Axxxx, Lxxxx E 100113621 1-1-12.pdf</SPAN> |
NDM I9 Adaxx, Mxxx 100117676 2-16-2012.pdf</SPAN> |
NDM I9 Adxxxx, Pxxx100117778 2-18-2012.pdf</SPAN> |
ADXXX, PXXX T 100117778.pdf</SPAN> |
<TBODY>
</TBODY>
Last edited: