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

#### midfieldgeneral11

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

Regan Tim
Brown Simon
Thrasyvoulou Anna

How can you change this around to read
Simon Brown

etc

Hope you help is needed thanks!

Simon

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Gettingbetter

##### Well-known Member
You can use a formula

=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

##### Well-known Member
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

##### MrExcel MVP
Hi

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

#### midfieldgeneral11

##### Active Member
Thanks very much for all your help!

Much appriciated

Si

:wink:

Replies
8
Views
431
Replies
1
Views
345
Replies
1
Views
382
Replies
31
Views
4K
Replies
3
Views
411

1,191,483
Messages
5,986,845
Members
440,053
Latest member
jhollingworth

### 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