Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Sorting Text with MS Excel
From:	Al Thompson <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 22 Sep 2004 14:58:04 -0700
Content-Type:	text/plain
Parts/Attachments:	text/plain (38 lines)

Dear Listers,

I have a text list of my DVD collection in MS Excel.
I would like to sort them alphabetically - easy enough, except for movies that start with  " The " or "A"

Currently, (part of ) the list reads as follows:

A Beautiful Mind
A Fish Called Wanda
Alien
Aliens
Alien 3
Flatliners
Star Trek Generations
The Bounty
The Hurricane

I would like to auto-sort the list (without having to change each cell manually) to read as follows:

Alien
Aliens
Alien 3
Beautiful Mind, A
Bounty, The
Fish Called Wanda, A
Flatliners
Hurricane, The
Star Trek Generations

Numerically-numbered movies  may come into play later, but for now a sorting like this would be helpful. Thanks
kindly!

Al Thompson

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG