I have a column that has multiple words, mostly names. I need to split them into two columns at the last space.

Examples:
Joe Doe
Joe & Jane Doe
Philip C. Merry
My Great Company
I need to have the names split as follows.

Column 1       Column 2
Joe            Doe
Joe & Jane     Doe
Philip C.      Merry
My Great       Company
My name column is currently starting at B2. I have seen instructions how to split at first space or how to split into First, Last and Middle names but I only need to split at the last space. Thanks in advance for your help.