Look for the first space from the right side of a cell

Hello all,

I am trying to remove the text from a string from the right side of a cell. Basically it will start from the right and look for the first space (" ") and then it will copy those characters into the next coulum and then remove them from the original string in the original cell. I have attached an example of what I am trying to accomplish. With the original text in coloum A.

Your help would be greatly appreciated.

Thank you.