Re: [users] Re: How to sort mixed alpha numbers?

2009-09-17 Thread Cor Nouws
Hi Gary, NoOp wrote (17-9-2009 2:10) On 09/15/2009 07:34 PM, jomali wrote: 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! I'm having trouble figuring that out... wouldn't be the first time :-) Would it be

[users] Re: How to sort mixed alpha numbers?

2009-09-17 Thread NoOp
On 09/15/2009 07:34 PM, jomali wrote: 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 Thank you, thank you, thank you! :-) - To

[users] Re: How to sort mixed alpha numbers?

2009-09-16 Thread Bob Estes
NoOp 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

[users] Re: How to sort mixed alpha numbers?

2009-09-16 Thread NoOp
On 09/15/2009 07:34 PM, jomali wrote: 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 I'm having trouble figuring that out... wouldn't be the first time :-) Would it be OK if I emailed you the

Re: [users] Re: How to sort mixed alpha numbers?

2009-09-16 Thread jomali
Sure, go ahead. I'd be glad to look at it. John On Wed, Sep 16, 2009 at 8:10 PM, NoOp gl...@sbcglobal.net wrote: On 09/15/2009 07:34 PM, jomali wrote: 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!

[users] Re: How to sort mixed alpha numbers?

2009-09-16 Thread NoOp
On 09/16/2009 05:31 PM, jomali wrote: Sure, go ahead. I'd be glad to look at it. John Thanks. It's on it's way (only 22.1KB) - email subject is Re: How to sort mixed alpha numbers? Gary - To unsubscribe, e-mail:

[users] Re: How to sort mixed alpha numbers?

2009-09-15 Thread NoOp
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

Re: [users] Re: How to sort mixed alpha numbers?

2009-09-15 Thread jomali
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 gl...@sbcglobal.net wrote: On 09/12/2009 01:51 AM, Bob Estes wrote: NoOp wrote: On 09/09/2009 08:35 PM, NoOp

[users] Re: How to sort mixed alpha numbers?

2009-09-12 Thread Bob Estes
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

[users] Re: How to sort mixed alpha numbers?

2009-09-11 Thread NoOp
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

[users] Re: How to sort mixed alpha numbers?

2009-09-10 Thread Twayne
NoOp gl...@sbcglobal.net wrote in message news:h89s6m$2t...@ger.gmane.org 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