Sort A-Z

[DAitkenOrchards_Golf]

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.

[#2]

Too bad there isn't a "Chat" option to get help from a Microsoft Support technician.

[#3]

@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 Which version of Windows operating system am I running?) or Mac/macOS Big Sur 11.2.1 (see Find out which macOS your Mac is using)
• Excel product name and version number (see About Office: What version of Office am I using?)
• 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!

[#4]

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 Which version of Windows operating system am I running?) or Mac/macOS Big Sur 11.2.1 (see Find out which macOS your Mac is using)
• Excel product name and version number (see About Office: What version of Office am I using?)
• 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!

[#5 · Accepted solution]

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?!

[#6]

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!