CHANGING FIRST AND LAST NAME

DEBORAHELLEN30

New Member
Joined
Aug 30, 2006
Messages
3
I have a column with first name first and last name last and would like to switch it with no commas. Is there a formula to do that with keeping them in the same column
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Book1
ABCD
1ToddBardoniBardoniTodd
Sheet1


Copy the formula down the column and then Copy the column with the formulas and Paste Special/Values in the column you want the names to appear. Then delete the column with the formulas.
 
Upvote 0
I have a column with first name first and last name last and would like to switch it with no commas. Is there a formula to do that with keeping them in the same column

In a word, no!! You will have to use a formula like Todd's or some tricks. If the column to the right is not blank, Insert a column to the right (For good measure, insert 3 or 4 columns). Next select your column and choose Data>Text to columns. Use a space as the delimiter. This will plae the First Name in 1 column and the Last Name in another column. Now Concatanate the 2 cells.
=B1&" "&A1
Select these cells and Copy>Paste Special>Values

Delete all extra columns.

lenze
 
Upvote 0

Forum statistics

Threads
1,226,588
Messages
6,191,889
Members
453,684
Latest member
Gretchenhines

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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