# Column Transfer

#### Bruins11

##### New Member
I have two columns of names. They refer to the same person, just in different order. IE Column A shows FirstName, LastName
Column B shows LastName, FirstName

What formula or function can I use to make Column A the same as Column B? (There is other data that goes with the names so I cant just copy, paste)...It seems as though I need a higher level "Find & Replace".

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### rsulliva

##### Board Regular
Try this formula where in this example the lookup cell is in A3

Code:
``=RIGHT(A3,LEN(A3)-FIND(" ",A3,1))&", "&(IF(ISERROR(FIND(" ",A3,1)),LEFT(A3,FIND(" ",A3,1)-1),LEFT(A3,FIND(" ",A3,1))))``

You could also try this one:
Code:
``=MID(A3&" "&A3, FIND(" ",A3)+1,LEN(A3))``

Rsulliva

Last edited:

Replies
4
Views
93
Replies
8
Views
56
Replies
0
Views
190
Replies
3
Views
109
Replies
3
Views
145

1,191,587
Messages
5,987,508
Members
440,098
Latest member
MickyMouse123

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