How do I put movie titles in alphabetical order

  • Thread starter Thread starter Allan
  • Start date Start date
A

Allan

I want to put all my movies that I have into a folder and then have them in
alphabetical order so they will be easy to find. I'm new to using any of
these programs. Just installed Office 2003 Basic.
Any help would be greatful, and please put in easy to understand
instructions, as I am slow understanding things.
 
Putting movie titles into a folder does not involve Excel.

Do you mean you want to list your movie titles in an Excel worksheet?

Type them into a column then select that column and Data>Sort>Ascending.


Gord Dibben MS Excel MVP
 
Putting movie titles into a folder does not involve Excel.

Do you mean you want to list your movie titles in an Excel worksheet?

Type them into a column then select that column and Data>Sort>Ascending.

Gord Dibben  MS Excel MVP



- Show quoted text -
Click to expand...
I'm having the same prolem. I want to sort movie titiles
alphabetically in Microsoft Excel, but movie titles that begin with
"the" are being sorted with the T's and I want them sorted as if the
title did not contain the "the". For instance I want the movie "The
Dirty Dozen" to be with movie titles beginning with D and not movie
titles beginning with T. Is there an way to do a sort such as this
without renaming the title without the "the" at the beginning??
 
bsp1913 wrote...I'm having the same prolem. I want to sort movie titiles
alphabetically in Microsoft Excel, but movie titles that begin with
"the" are being sorted with the T's and I want them sorted as if the
title did not contain the "the". For instance I want the movie "The
Dirty Dozen" to be with movie titles beginning with D and not movie
titles beginning with T. Is there an way to do a sort such as this
without renaming the title without the "the" at the beginning??

You will have to create a "helper column" for sorting
see "Sorting Titles" by Jim Cone
http://groups.google.com/group/micr...0ca56c1091e/c57f0b47bd354d4e#c57f0b47bd354d4e
 
Back
Top