How to pull Certain Text/Names from a Data String

[Adroit]

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.

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>

 

[Adroit]

Anyone?

 

[konew1]

Hi. Your data is not entirely consisent so no solution will be perfect. I put together this. It identified that the second last line the name runs into the number without a space. I also realised that some names have what might be an initial, or might be part of the other data. This solution excludes it. If you ever have more than 2 spaces before the name then this will return an incorrect result. You should be able to modify the IF to allow for it necessary.
IF(LEN(LEFT(A2,FIND(",",A2)))-LEN(SUBSTITUTE(LEFT(A2,FIND(",",A2))," ",""))=1,MID(A2,FIND(" ",A2),FIND(" ",A2,FIND(",",A2)+2)-FIND(" ",A2)),MID(A2,FIND(" ",A2,FIND(" ",A2)+1),FIND(" ",A2,FIND(",",A2)+2)-FIND(" ",A2,FIND(" ",A2)+1)))
I expect this can be simplified.

 

[Robert Mika]

Anyone?

Look here:
http://www.mrexcel.com/forum/newreply.php?do=postreply&t=647178