Forum Discussion
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...
- 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?!
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?!
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?!
- 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!
