# Switching First and last name

#### delwinsr

##### New Member
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?

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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

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

The names are in one column.

For example:

Lopez Juan

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.

Thanks so much for the help.

Replies
2
Views
371
Replies
3
Views
134
Replies
0
Views
131
Replies
6
Views
167
Replies
2
Views
97

1,203,620
Messages
6,056,330
Members
444,861
Latest member
B4you_Andrea

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back