Switching First and last name

[delwinsr]

When you have a spreadsheet and the last name comes first is there a way to switch it so that the first name appears first without having to go 1 by 1?

 

[rs2k]

You could use text to columns then concat them after. If you need help with this post back and explain how the names are laid out at present.

Are the both names in one cell to begin with?

Colin

 

[DominicB]

Good evening delwinsr

You haven't said what seperator there is, but for the example here I'll assume it's a space.

=RIGHT(D11,(LEN(D11)-FIND(" ",D11)))&" "&LEFT(D11,FIND(" ",D11))

The above is the formula you need but you might have to tweak it for your ranges etc. Put the formula in a spare cell and copy it down, and then if you need to, you could copy it back over the original range using copy - paste values.

HTH

DominicB

 

[delwinsr]

The names are in one column.

For example:

Lopez Juan

 

[rs2k]

Highlight the column of names;
Data|Text to Columns, choose-Delimited and then check Space. and follow the instructions to finish.

Once they have been split into two columns (Last name & First name) in a spare column (C?) enter this formula =B1&" "&A1

The formula assumes that the names are in column A to start with, will be split into Col A & Col B after the 'Text to Columns' and Col C will put them back together with the first name at the begining. Copy the formula down as far as needed.

HTH
Colin.

 

[delwinsr]

Thanks so much for the help.