I've found the following formula which extracts the first set of words to the limit of 50 characters
=TRIM(LEFT(LEFT(A1,25),FIND("^^",SUBSTITUTE(LEFT(A1,25)," ","^^",LEN(LEFT(A1,25))-LEN(SUBSTITUTE(LEFT(A1,25)," ",""))))))
I've managed to adapt this to get the next set of whole words
=TRIM(MID(A1,(FIND("^^",SUBSTITUTE(LEFT(A1,50)," ","^^",LEN(LEFT(A1,50))-LEN(SUBSTITUTE(LEFT(A1,50)," ",""))))),50))
My problem is I need formulas further sets of words limited to 50 characters after the 2nd set as I can't get a formula to pull the next set of words. In total I'm trying to extract about 10 lines worth of whole words in total so any help would be greatly appreciated.