Swapping Text

[jbmystic]

Hi,

Could someone point me in the right direction please? I want to change a list of names around (the full name is within one cell):

From this
John Smith
Grant Andrews
Matthew Baker

To this

Smith John
Andrews Grant
Baker Matthew

Many thanks in advance

 

[facethegod]

IF your Names are in column A.. try in column B


=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1))