Swapping cells data

[Andy P]

I have a name in a cell - David Bailey

How do I get another cell to show it as Bailey David.

I thought the Replace function could do it!

Thanks

Andrew

 

[Frank Kabel]

Hi
see:
http://cpearson.com/excel/FirstLast.htm