Spaces between names

[Iain]

Hi,

I have a column called name which has lastname followed
by firstname. I want to swap them around.
So instead of 'Smith Jim' it will say 'Jim Smith'

TIA
Iain

 

[Peo Sjoblom]

What if the name is

Edson Arantes do Nascimento III

or something?

If it is just 2 names the easiest way would probably to use
data>text to columns with space as delimiter to separate them,
then use a formula like this in a help column

=B2&" "&A2

copy down as long as needed and copy and paste
special as values. However it is rather complicated
since names can be so diverse..

 

[Anon]

Hi,

I have a column called name which has lastname followed
by firstname. I want to swap them around.
So instead of 'Smith Jim' it will say 'Jim Smith'

TIA
Iain

For names in column A starting at A1, put this formula in B1 and copy down
column B as far as required:
=MID(A1,FIND(" ",A1)+1,99)&" "&LEFT(A1,FIND(" ",A1)-1)

If you wish, you can then copy column B and paste values to get just the
results (instead of the formulas).