LinkBack URL
About LinkBacks
how do i get two columns of first and last names into ONE cell and reverse?
excel hell
how do i get two columns of first and last names into ONE cell and reverse?
Formatted as John Smith:Originally Posted by rroblu
=A1&" "&B1
Formatted as Smith, John
=B1&", "&A1
Hope this helps!
This much i understand but where do i do the formula??? I tried to put it in where the fx is and i got nothing. i need step by step help. if anyone has a moment i would really appreciate it! thanks
robyn
go to the cell you want the formula in then type = a1 & " " &b1 what this does takes the value from cell a1 and then " " means there is a space and then takes the value of b1 and that is the value. the & sign means combine values without adding.
hope this helps.
What I Need To Know Is What Actions Do I Take. Physically What Do I Click On Tho Make The Formula Work And Also Work All The Way Down My Column I Have 1045 Names To Do This To And I Do Not Know What To Do After I Put The Formula In The Little Cell.
Thanks For Your Time
I'll try to explain the basics of Excel in short terms. As I don't know your layout, you will have to modify the cell references to match your file: (Note: Save your file before you begin...just in case!!)
If your names are in Columns A and B, in column C enter this formula next to the name at the top of your list: (if column C already has data in it, you will need to insert a column--type "Insert Column" in HELP to find out how)
=B1&", "&A1 <<NOTE: this formula assumes you are in row 1, change the 1 if needed to match the actual row your data is in>>
Type the above formula exactly as it appears, there is a space after the comma.
Press the Enter key and you should now see "Lastname, Firstname" in your cell
(no quotes)
Click in this cell to select it, you will see the dark box that outlines this cell, notice it has a small black box in the lower righthand corner.
Move your cursor over top of this box and the cursor changes to a small cross. Click and hold down the mouse button and "drag" down (notice that a rectangle is drawn to show the range you are covering). When you reach the end of your data, release your mouse button. Your formula is now copied into all the cells in this column. Each cell should now display the names joined as described above.
Good Luck
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks