Spaces between names

  • Thread starter Thread starter Iain
  • Start date Start date
I

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
 
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..
 
Iain said:
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
Click to expand...

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).
 
Back
Top