ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HOW TO ALPHABETIZE EXCEL LIST OF NAMES (https://www.excelbanter.com/excel-programming/360217-how-alphabetize-excel-list-names.html)

ROSEANN

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.

Tom Ogilvy

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.


ROSEANN

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.


Tom Ogilvy

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.


ROSEANN

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.



All times are GMT +1. The time now is 06:18 AM.

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