Alphabetizing omitting the word "the"

wakariamsen · Newbie Joined: 03 Feb 2009 Posts: 1

Can this be done?

I want to create a list of movies and alphabetize them according to title. There are some films that begin with the word "The", which want to keep listed at the beginning of their title. However, when alphabetizing them, I want Calc to ignore "The" and alphabetize these titles based on the second word of their titles.

For example, I would like "The Dark Knight" to appear just as this, but alphabetized among the D's....

Can I tell Calc to ignore "The" when alphabetizing, or will I have to take care of these ones manually?

thanks!

Robert Tucker · Posted: Tue Feb 03, 2009 2:11 am Post subject:

Maybe something like:

Copy (duplicate) your column into another column.Select/click on the second column and search for "The " and replace with nothing with "Match case" selected (you also need to have "Current selection only" checked under "More options"). Data>Sort and sort on your new column only. Delete new column.
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)