Forum Discussion
DAitkenOrchards_Golf
Jul 09, 2021Copper Contributor
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...
- Jul 09, 2021Normaly 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?!
Lorenzo
Jul 09, 2021Silver Contributor
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!