Hello,
I was given great assistance on another excel problem I had so I was hoping I'd be able to get additional help on another one.
With the provided data set below, how would I be able to pull out only the names? Note that I substituted "X" for portions of the names as this is actual data. Thanks.
<TBODY>
</TBODY>
I was given great assistance on another excel problem I had so I was hoping I'd be able to get additional help on another one.
With the provided data set below, how would I be able to pull out only the names? Note that I substituted "X" for portions of the names as this is actual data. Thanks.
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>