Is this what you need?
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",200)),200,800))[/QUOTE
That seems to extract words 2, 3, 4 and 5.
Thanks, you are right. Corrected version:
=TRIM(MID(SUBSTITUTE(" "&A1," ",REPT(" ",200)),200,800))
István should have written it either this way...Is this what you need?
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",200)),200,800))[/QUOTE
That seems to extract words 2, 3, 4 and 5.
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",200)),1,800))
or this way...
=TRIM(MID(SUBSTITUTE(" "&A1," ",REPT(" ",200)),200,800))
István should have written it either this way...
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",200)),1,800))
or this way...
=TRIM(MID(SUBSTITUTE(" "&A1," ",REPT(" ",200)),200,800))
Thanks Rick, modified in the meantime to the second version. Still, the formula in post #3 is better than mine.