+ Reply to Thread
Results 1 to 5 of 5

HOW TO ALPHABETIZE EXCEL LIST OF NAMES

  1. #1
    ROSEANN
    Guest

    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. #2
    Tom Ogilvy
    Guest

    RE: 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. #3
    ROSEANN
    Guest

    RE: 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. #4
    Tom Ogilvy
    Guest

    RE: HOW TO ALPHABETIZE EXCEL LIST OF NAMES

    send me a sample of your data that won't sort properly to

    [email protected]

    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. #5
    ROSEANN
    Guest

    RE: 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
    >
    > [email protected]
    >
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1