 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008How do I put movie titles in alphabetical order
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 >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. > [quoted text clipped - 11 lines] > > - 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?? bsp1913 wrote... > >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.- Hide 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?? You will have to create a "helper column" for sorting see "Sorting Titles" by Jim Cone http://groups.google.com/group/microsoft.public.excel.newusers/browse_frm/thread /caa500ca56c1091e/c57f0b47bd354d4e#c57f0b47bd354d4e  SignatureHTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.