Chainsaw,

as I see it you are looking for an alphabetic sort of data that can be
numeric. Obviously, 3A would be treated by Excel as text, whereas, 3, would
generally be treated as a number.

The simplest method to achieve your sort is to format the column containing
the references as text. Format/Cells/Number and select text as the format,
then try your sort. My memory of this is that in Excel 97 and prior, that it
would sort 11 after 1 and before 2, having just tried this in Excel XP, that
is no longer the case.

Steve
"chainsaw" wrote in message
...

I am trying to sort data in a specific manner. My column shows
1
2
3
4
5
310
3A
3B

When sorted I want it to show
1
2
3
310
3A
3B
4
5

How can I get it to sort starting with the left most character and work
to the right and then down?


--
chainsaw
------------------------------------------------------------------------
chainsaw's Profile:
http://www.excelforum.com/member.php...fo&userid=5976
View this thread: http://www.excelforum.com/showthread...hreadid=314426