How do I put movie titles in alphabetical order

[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.

 

[Gord Dibben]

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

 

[bsp1913]

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 -

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??

 

[David McRitchie]

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