MAybe this:
=--TRIM(RIGHT(SUBSTITUTE(LEFT(A1,LEN(A1)/2)," ",REPT(" ",50)),70))
Actually, it doesn't look 4th or 5th space from the right but look at the middle of the word...
So test for all other cases you have and we'll see where it does mistake...
Bookmarks