Swapping cells data

A

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
 
Top