by Captain Sensible » Wed Sep 23, 2015 7:40 pm
Are you looking for a formula or VBA?
Here's a formula to pick out the 4th word in a text string in cell A1
=MID(MID(MID(SUBSTITUTE(A1," ","^",3),1,256),FIND("^",SUBSTITUTE(A1," ","^",3)),256),2,FIND(" ",MID(MID(SUBSTITUTE(A1," ","^",3),1,256),FIND("^",SUBSTITUTE(A1," ","^",3)),256))-2)
If it's a regular format it might be better for you to write a small VBA function using split in VBA rather than using long formulas