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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Any Excel gurus out there?

  • 19-11-2008 6:19pm
    #1
    Lex Luthor
    Registered Users, Registered Users 2 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

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


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


  • #3
    Lex Luthor
    Registered Users, Registered Users 2 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