Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to sort a column of information... please help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move exact information in a row as you sort a column | Excel Worksheet Functions | |||
Sort information according to colors in Excel | Setting up and Configuration of Excel | |||
How does one sort a block of inter-related information in Excel? | Excel Worksheet Functions | |||
Sort a list with uneven row information | Excel Worksheet Functions | |||
how do i import data from excel, sort it then that information is. | Excel Discussion (Misc queries) |