this code only for your reference.
I think your data is too complicated to solve

=RIGHT(A9,LEN(A9)-FIND(" ",A9))