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
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
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
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
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!
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:
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
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
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
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
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
11 matches
Mail list logo