Hello Jason,

Thanks..But I am not that good with excel..so could you explain how to
extract the by the three middle numbers and sort the complete number in a
new column.
Sorry for all the questions.

"Jason Morin" wrote:

You can extract the 3 middle characters to a new column and then sort on that
new
column.

=MID(A1,7,3)

HTH
Jason
Atlanta, GA

"bagman" wrote:

How do you sort a column of numbers with hyphens?
Example #####-###-####.
I want to sort by the 3 middle numbers
Thanks