Using a formula I wish to be able to convert a whole column of names
formatted as follows

1. SMITH, Dane
2. ALLENBY, Gary
3. MCDONALD, Leigh
4. O'CONNOR, Paul
5. MAYFIELD-SMITH, Jimmy
6. HARRISON, Lenny

to

Dane Smith
Gary Allenby
Leigh McDonald
Paul O'Connor
Jimmy Mayfield-Smith
Lenny Harrison

I have hundreds of names that need to be converted so changing manually
would be very time consuming. Any help on this would be greatly appreciated.