Forum Discussion

DAitkenOrchards_Golf's avatar
DAitkenOrchards_Golf
Copper Contributor
Jul 09, 2021
Solved

Sort A-Z

I have combined 3 lists of "Last Name/First Name" into one "Sheet." Names for rows "2-116" are alphabetized (A-Z), followed by separately alphabetized (A-Z) Names in rows "117-288." I want to combine these Names into ONE alphabetized list. I have tried several times to combine these groups into one alphabetized list (including "Cut and Pasting" the bottom group of alphabetized names above the top group), but haven't been successful. Please provide a solution. Thank you.

Formulas and Functions
  • German_Chris's avatar
    German_Chris
    Jul 09, 2021
    Normaly this should work without any problems.
    Click one of the cells in column, then DATA->SORTING->A-Z

    If this did not work, Check your data, maybe there is an Space as first character in some of the cells?!

4 Replies

  • German_Chris's avatar
    German_Chris
    Iron Contributor
    Jul 09, 2021
    Normaly this should work without any problems.
    Click one of the cells in column, then DATA->SORTING->A-Z

    If this did not work, Check your data, maybe there is an Space as first character in some of the cells?!
    • DAitkenOrchards_Golf's avatar
      DAitkenOrchards_Golf
      Copper Contributor
      Jul 09, 2021
      Thank you for your suggestion. I'm unsure how it happened, but all First Names were preceded by a "space." When I deleted each "space" individually , and marked each "Last" and "First" Names, then "Sort(ed) A-Z," it alphabetized as I needed. That was the solution. Thank you, Christian!
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jul 09, 2021

    DAitkenOrchards_Golf 

    Welcome to your Excel discussion space! 

     

    If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.

     

    Please include the following info to help others answer your question:

    • Device and OS platform, e.g., PC/Windows 10 (see https://support.microsoft.com/en-us/windows/which-version-of-windows-operating-system-am-i-running-628bec99-476a-2c13-5296-9dd081cdd808) or Mac/macOS Big Sur 11.2.1 (see https://support.apple.com/en-us/HT201260)
    • Excel product name and version number (see https://support.microsoft.com/en-us/office/about-office-what-version-of-office-am-i-using-932788b8-a3ce-44bf-bb09-e334518b8b19)
    • Excel file you’re working with or sample file with data – please remove all confidential and PII data 
    • As much context of what you're trying to do - and why - as possible, e.g., how what you're trying to do fits into what larger process or workflow*
    • Expected result and method to achieve the result**

     

    Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question.

     

    Thanks!

Resources