Hello Excel Community,
I am having issues on sorting data alphabetically from A-Z including symbols (aka -, &, _ etc.). I'd like it so that when I sort alphabetically any data that the symbols move to the top of the alphabetized list. Is there a specific way to do this?
I noticed that my colleague has a MAC and her excel workbooks already sort with symbols first when alphabetizing. Is this something we can hardcode every time I open excel?
See example below of what I'd like to do:
Example Data to be sorted
Hughes
Heyden
Hartman
Hampton
Hurri-Bolt
H-K&W
Hahn
Hardware
Harmco
Humboldt
Example Data sorted [A-Z] << this is how my current excel sheet sorts
Hahn
Hampton
Hardware
Harmco
Hartman
Heyden
H-K&W
Hughes
Humboldt
Hurri-Bolt
Example Data sorted [A-Z] with symbols on top << this is how I want it to sort!
H-K&W
Hahn
Hampton
Hardware
Harmco
Hartman
Heyden
Hughes
Humboldt
Hurri-Bolt
Thank you so much for your help!!
Kindly,
Andrea
