View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Trying to sort a column of information... please help

As long as area code is first in the cells, an alphabetical sort will do
what you want.

Regards,
Fred.

"Todd Allen" wrote in message
...
I am trying to sort information in Excel 2003

I have a column of phone numbers - I am trying to sort them by U.S. area
code. The only sort function i see is alphabetical.

Is there a way i can do this?

--
Todd Allen
Chicago IL