| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO ALPHABETIZE EXCEL LIST OF NAMES
I AM WORKING ON AN EXCEL SPREADSHEET THAT WILL LIST ABOUT A 100 NAMES. I WANT
THESE NAMES FORMATTED ALPHABETICALLY. IS THERE A FUNCTION THAT WILL DO THIS AUTOMATICALLY? THANKS. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO ALPHABETIZE EXCEL LIST OF NAMES
If you only want one copy of the list, then you would need to select the list
and do Data=Sort. -- Regards, Tom Ogilvy "ROSEANN" wrote: I AM WORKING ON AN EXCEL SPREADSHEET THAT WILL LIST ABOUT A 100 NAMES. I WANT THESE NAMES FORMATTED ALPHABETICALLY. IS THERE A FUNCTION THAT WILL DO THIS AUTOMATICALLY? THANKS. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO ALPHABETIZE EXCEL LIST OF NAMES
WHAT FORMULA DO I PUT IT BECAUSE IT WON'T FORMAT IT IN ALPHABETICAL ORDER.
THANKS. "Tom Ogilvy" wrote: If you only want one copy of the list, then you would need to select the list and do Data=Sort. -- Regards, Tom Ogilvy "ROSEANN" wrote: I AM WORKING ON AN EXCEL SPREADSHEET THAT WILL LIST ABOUT A 100 NAMES. I WANT THESE NAMES FORMATTED ALPHABETICALLY. IS THERE A FUNCTION THAT WILL DO THIS AUTOMATICALLY? THANKS. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO ALPHABETIZE EXCEL LIST OF NAMES
send me a sample of your data that won't sort properly to
Make sure you send your email address so I can return it. -- Regards, Tom Ogilvy "ROSEANN" wrote: WHAT FORMULA DO I PUT IT BECAUSE IT WON'T FORMAT IT IN ALPHABETICAL ORDER. THANKS. "Tom Ogilvy" wrote: If you only want one copy of the list, then you would need to select the list and do Data=Sort. -- Regards, Tom Ogilvy "ROSEANN" wrote: I AM WORKING ON AN EXCEL SPREADSHEET THAT WILL LIST ABOUT A 100 NAMES. I WANT THESE NAMES FORMATTED ALPHABETICALLY. IS THERE A FUNCTION THAT WILL DO THIS AUTOMATICALLY? THANKS. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO ALPHABETIZE EXCEL LIST OF NAMES
I just sent the file to you. Thanks so much for all your help.
"Tom Ogilvy" wrote: send me a sample of your data that won't sort properly to Make sure you send your email address so I can return it. -- Regards, Tom Ogilvy "ROSEANN" wrote: WHAT FORMULA DO I PUT IT BECAUSE IT WON'T FORMAT IT IN ALPHABETICAL ORDER. THANKS. "Tom Ogilvy" wrote: If you only want one copy of the list, then you would need to select the list and do Data=Sort. -- Regards, Tom Ogilvy "ROSEANN" wrote: I AM WORKING ON AN EXCEL SPREADSHEET THAT WILL LIST ABOUT A 100 NAMES. I WANT THESE NAMES FORMATTED ALPHABETICALLY. IS THERE A FUNCTION THAT WILL DO THIS AUTOMATICALLY? THANKS. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO YOU ALPHABETIZE A LIST OF NAMES IN AN EXCELL SPREADSHEET? | Excel Discussion (Misc queries) | |||
| HOW DO i ALPHABETIZE A LIST OF SCHOOL (NOT NAMES) IN EXCEL | New Users to Excel | |||
| alphabetize the names colum on the excel | New Users to Excel | |||
| Can I use excel (or any program) to alphabetize names? | Excel Discussion (Misc queries) | |||
| Can excel alphabetize a list of names? | Excel Worksheet Functions | |||
Linear Mode
