One way is to use TTC (Text To Columns).

Select the data in the column, then <Data <TTC,
Click "Fixed Width", then <Next,
Click in the window, and drag the break line to separate the "C" from the
numbers, then <Next.

The column containing the "C" should be selected (black), so click on "Do
Not Import (skip)".

Then click in the "Destination" window, and enter the address of the column
next to your original.
What this does is preserve your data in it's original location, without
changing anything, and moves *only* the numbers to the next column, skipping
(leaving behind) the letters.
Now, click <Finish.

You should now have your original column of data, and an adjoining column of
numbers, where you now select *both* columns, and sort on the number column
to get your text column of data sorted numerically.

You can then delete the "helper' column of numbers.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"dancefle" wrote in message
...
How do I change a column containing c1 c10 c11 c2 c21 c3 to sort as c1 c2
c3
c10 c11 c21?