Put the formula
=MID(A1;FIND(" ";A1);LEN(A1))+0
in Cell B1.
Extend down as far as your data in Column A goes.
Sort on column B
Voila!John On Tue, Sep 15, 2009 at 6:30 PM, NoOp <[email protected]> wrote: > On 09/12/2009 01:51 AM, Bob Estes wrote: > > 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 > > Thanks all. The regatta is over so now I'll have time to experiment. > What I did (the night before the regatta) was copy the data from a web > page (http://www.big-boat-series.com/Event/CurrentEntries.aspx) and > pasted into Calc. I had hoped to sort by sail numbers so that I'd have > an easy reference list as the boats come around my marks (I work > on-water Race Committee). > Turns out I survived without it, but I still want to figure out the sort > puzzle for future situations. A 96 boat list isn't that hard to > manipulate, but anything larger might require a macro if I can't figure > out a simple way to do it with the sort feature. > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
