extract name based on condition

Originally Posted by FDibbins

Based on your sample data, use this, copied down...
=IF(SEARCH(" ",A2,1)<=4,MID(A2,SEARCH(" ",A2,SEARCH(" ",A2,1)+1)+1,99),LEFT(A2,SEARCH(" ",A2,1)-1))

Exactly what I was thinking of except for the MID(second space, 99 characters) I would have gone for RIGHT(LEN minus second space), but I guess it's pretty safe to say there are no Phillipine namnes with more than 99 characters