+ Reply to Thread
Results 1 to 3 of 3

Sorting a table into alphabetical order?

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    20

    Sorting a table into alphabetical order?

    So i have a column full of first and surnames (both names in one cell).
    Is there a fast way to arrange them in alphabetical order? (surnames)

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,549

    Re: Sorting a table into alphabetical order?

    if all the names are just first and last and so you have on space only

    copy the column into a helper column
    then on that helper column - use
    DATA > TEXT to columns
    delimited > SPACE
    now all the surnames are in a column of there own

    select the range including your original list and sort by the new surmane list

    see here http://www.extendoffice.com/document...last-name.html
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,508

    Re: Sorting a table into alphabetical order?

    Hi,

    It would be far simpler if you simply extracted the first names and surnames into their own columns, and then sorted on those.

    Have a look at the Text to Columns feature (Data tab).

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sorting letters in words into alphabetical order
    By bobf in forum Excel General
    Replies: 9
    Last Post: 07-24-2017, 07:35 AM
  2. Automatically sorting in to alphabetical order
    By macky18 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-15-2013, 07:45 AM
  3. Sorting the alphabetical order with semicolon in each cell.
    By spiderkzn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2012, 09:55 AM
  4. [SOLVED] Sorting Colums into alphabetical order
    By tox in forum Excel General
    Replies: 3
    Last Post: 02-22-2005, 12:06 PM
  5. [SOLVED] Sorting rows into alphabetical order?
    By tox in forum Excel General
    Replies: 8
    Last Post: 02-04-2005, 07:08 PM

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