View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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