> Inserrt a new Column B and enter the numbers 1 - 10. Hide column B and
> then select the data that you want to sort and sort by Column B
[quoted text clipped - 11 lines]
>> The only work around I have found so far is to change "10" to "ten" for
>> the sorting procedure and then changing "ten" back to "10" when I'm done.
You can even make it easier for yourself when using TTC, so that you *don't*
have to put your data back together again (concatenate).
After you click on <Space> as the delimiter, don't click <Finish>.
Click <Next> to get to the 3rd step of the TTC Wizard.
There, you'll see in the "data preview" window, that the first column
containing Team is selected, by default.
Click on "Do Not Import Column (skip)",
Then, in the "Destination" box, change the column letter to the next column
(depending on where your original data was located), meaning:
If the box displays A1 ... change to B1
If the box displays D12 ... change to E12
THEN click <Finish>
This leaves your original data *untouched*, while copying the numbers to the
adjoining column.
Now, just sort both columns on the number column, and then delete the number
column, leaving your original data sorted, and in it's original form as
data, not concatenate formulas that may have to be transformed back to data
values.

Signature
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> Know what I did? I actually used "text to columns - delimited" to separate
> the numerals from the word "team." (I actually had a long list than the one
[quoted text clipped - 20 lines]
> >> The only work around I have found so far is to change "10" to "ten" for
> >> the sorting procedure and then changing "ten" back to "10" when I'm done.
BK - 02 Jan 2008 22:11 GMT
Very cool!!! Thanks~!!
> You can even make it easier for yourself when using TTC, so that you
> *don't*
[quoted text clipped - 55 lines]
>> >> the sorting procedure and then changing "ten" back to "10" when I'm
> done.
Ragdyer - 03 Jan 2008 01:22 GMT
You're welcome, and thanks for the feed-back.

Signature
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
> Very cool!!! Thanks~!!
>
[quoted text clipped - 62 lines]
> >> >> the sorting procedure and then changing "ten" back to "10" when I'm
> > done.