Names Changing them around.....easy please look

[midfieldgeneral11]

I have a list of names like the below in each cell

Regan Tim
Brown Simon
Thrasyvoulou Anna
Rhoades Tony

How can you change this around to read
Simon Brown

etc

Hope you help is needed thanks!

Simon

 

[Gettingbetter]

You can use a formula

where B2 is your cell
=MID(B2,FIND(" ",B2,1)+1,LEN(B2))&" "&LEFT(B2,FIND(" ",B2,1)-1)

or you could highlight your column and do from the toolbar
Data, Text to columns
Then click the delimited option and choose next, then ctick spaces
This will seperate your column by spaces.

Cheers
GB

 

[ravishankar]

Hi
if B2 has the string then insert this formula in c2
=MID(B2,FIND(" ",B2)+1,100) & ", " & LEFT(B2,FIND(" ",B2)-1)
Drag it till the end of data
Ravi

 

[jindon]

Hi

=Mid(A1&" "&A1,Find(" ",A1)+1,Len(A1))

 

[midfieldgeneral11]

Thanks very much for all your help!

Much appriciated

Si

:wink: