Thread: Changing the position of names

Hi

I have a list of thousands of names (Sur name then First name) in a tool:

Richard,Dell
Mexas, Brown
Howells, David

etc. etc.

I copy them and paste them in Excel File (say Column A); then I arrange them (in same column) manually to appear as:

Dell Richard
Brown Mexas
David Howells

Please help me with a formula to make them arrange automatically as they are arranged manually without comma.

Thanks