Excel 2007 : Changing the position of names

[sushil10s]

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

[sweep]

Hi,

Try this?

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)