Sort Data Alphabetically Including Symbols

Occasional Visitor

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

1 Reply

yes,Excel buildin sort looks different。

I sort them with sql looks normal。

 select * from Sort_by_custom_order where F_A!='' order by F_A 

Screenshot_2022-12-17-06-50-28-902_cn.uujian.browser.jpg