Title Case Sort

Hi there! First, thanks for Gnumeric, it's awesome!

I've put a list of the books I own into Gnumeric and I'm trying to
find the best way to do a title sort - if the first word is an
article, it should not be considered part of the name. Here's an
example of a normal sort:

The Barrier

And I want to sort it like so:

The Barrier

My solution so far is to make a hidden column with the following
formula (the book title is column A):

=if(exact(left(A5,2),"A "),replace(A5,1,2,""),if(exact(left(A5,3),"An

Then I sort based on the hidden column rather than the title column.
This works, but it seems a little inelegant; is there a better way to
do it? Thanks!

Taylor C. Venable

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]