If you always have only one "C" at the left you might want to try this array formula:
(assume your data is in A1:A6)
="C"&SMALL((RIGHT($A$1:$A$6,LEN($A$1:$A$6)-1))*1,ROW(A1))
(hold down Ctrl and Shift while pressing Enter)

Regards
Hans


"JLW" skrev i en meddelelse ...
I would like to sort values for numbered connectors such as C1, C2, C3,
...... C200. However, excel is sorting it as C1, C100, C11, C123, etc. How
do I change this???