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
|