One way:

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

But this only works if all your data is exactly like the example
below.

Check out http://www.cpearson.com/excel/FirstLast.htm for more
samples.

HTH,
JP


On Apr 5, 8:16*am, Kimmie23
wrote:
Can someone please explain how to invert all the cel entries in an excel
spread sheet. i.e. John and Sally Hancock becomes Hancock, John and Sally?