Changing text Around? ?Around text Changing....Can you help

[midfieldgeneral11]

Good Afternoon

I have a list of names in a long list of 5,000 items.

For each person I have two entries like this?

WILLIAMS SIMON
Simon Williams

What I would like is a formulae which looks at the list and transforms WILLIAMS Simon into Simon Williams.

This needs to be all lower case and like this. Some entries will be already like Colin Williams and would like these to leave this alone if this can be done.

Or I can simply create a new folder and filter out the ones and change them with the formaule in a formaule.

Can you help?

Cheers
Simon

 

[VoG]

Try

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

Excel has no way of knowing what is a first name and what is a second name.