alphanumeric sort

Giganews Newsgroups
Subject: alphanumeric sort
Posted by:  JLW
Date: Fri, 26 May 2006

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???

Replies