Extract last word

try this:
In C2

=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255))

In B2:

=SUBSTITUTE(A2,E2,"")

Copy both down