Hi,

Can someone help me to come up with the formula to get the middle word for this example:

0001 AB10846 Group Assoc NetAdmn
0001 AB10854 Indv Func NetAdmn
.
..
... and so on.

For the 2nd word I have this formula:

=TRIM(IF(ISERROR(FIND(" ",C1,1)),C1,MID(C1,FIND(" ",C1,1)+1,IF(ISERROR(FIND(" ",C1,FIND(" ",C1,1)+2)),LEN(C1),FIND(" ",C1,FIND(" ",C1,1)+2))-FIND(" ",C1,1))))

And now I need to get the 3nd and 4th word separately.

I appreciate your help.

Thanks!