ExcelBanter - sort cells with hyphen #####-###-####

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sort cells with hyphen #####-###-#### (https://www.excelbanter.com/excel-discussion-misc-queries/2810-sort-cells-hyphen.html)

infurtaris

sort cells with hyphen #####-###-####

How do you sort a column of numbers that have hyphens?
Example #####-###-####.
I would like to sort by the 3 middle numbers.
Thanks

All times are GMT +1. The time now is 12:12 AM.