ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Trying to sort a column of information... please help (https://www.excelbanter.com/excel-worksheet-functions/178908-trying-sort-column-information-please-help.html)

Todd Allen

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

Fred Smith[_4_]

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




All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com