Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Any Excel gurus out there?

Options
  • 19-11-2008 7:19pm
    #1
    Lex Luthor
    Registered Users Posts: 11,220 ✭✭✭✭


    I have a spreadsheet with a column of names, not in alphabetical order.

    However the name in the cell is in the format Firstname Surname

    I want to sort the column alphabetically, but by Surname

    Is there any way I can flip the name in the cells by having them Surname Firstname without having to retype them all? Then I can sort by surname alphabetically


Comments

  • Options
    #2
    rockal
    Registered Users Posts: 757 ✭✭✭rockal


    Select column. Go to 'Data' - 'Text to Columns' - 'Delimited' -then select 'space'. This will give you two separate columns.


  • Options
    #3
    Lex Luthor
    Registered Users Posts: 11,220 ✭✭✭✭Lex Luthor


    rockal wrote: »
    Select column. Go to 'Data' - 'Text to Columns' - 'Delimited' -then select 'space'. This will give you two separate columns.

    excellent mate, thanks


Advertisement