NoOp wrote:
On 09/09/2009 08:35 PM, NoOp wrote:
I've tried every combination that I can think of (even formating cells
to text) and still cannot figure out how to sort via a column with data
like this:
Sail Number
USA 84
USA 604
USA 275
USA 35024
USA 103
USA 116
USA 38747
USA 72
USA 40
USA 87549
USA 41001
USA 52
USA 28719
Any suggestions?
Thanks to all that offered suggestions... I'll have to give them a try
when I'm back from sailing on Monday.
Gary (NoOp)
I found a way that works reasonably well. First, I copied the list into
column B of a Calc spreadsheet with each entry on its own line. I then
deleted the USA from each row and reinserted it in column A. As part of
the test, I added a couple of entries each for UK and AUS numbers. I
then selected the data to be sorted. I then selected "DATA/SORT, Sort
by column A then by column B". On the options tab, I then selected
"Enable natural sort". Clicking on OK sorted the data first by country
and then by number. This was an alphabetical sort instead of an ASCII
sort which is what I think you wanted. This sounds like a long
procedure, but it took me longer to write up the explanation than it did
to do the sort.
I hope this helps.
Bob
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
