+ Reply to Thread
Results 1 to 8 of 8

excel hell

  1. #1
    Registered User
    Join Date
    02-09-2005
    Posts
    4

    Exclamation excel hell

    how do i get two columns of first and last names into ONE cell and reverse?

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    Quote Originally Posted by rroblu
    how do i get two columns of first and last names into ONE cell and reverse?
    Formatted as John Smith:

    =A1&" "&B1

    Formatted as Smith, John

    =B1&", "&A1

    Hope this helps!

  3. #3
    Registered User
    Join Date
    02-09-2005
    Posts
    4

    help!

    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

  4. #4
    Forum Contributor funkymonkUK's Avatar
    Join Date
    01-07-2005
    Location
    London, England
    Posts
    500
    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.

  5. #5
    Registered User
    Join Date
    02-09-2005
    Posts
    4
    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

  6. #6
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    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

  7. #7
    Registered User
    Join Date
    02-09-2005
    Posts
    4

    Talking thanks

    Bruce, it worked thank you, i do at least know inserting and dragging and once i even waterski'd! but this had me perplexed! THANK YOU SOOOO MUCH!
    Last edited by rroblu; 02-10-2005 at 01:45 PM.

  8. #8
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Glad it worked for you. Hmmm, I've never water ski'd! I'm impressed!

    Thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1