With the data in column A,try in column B:
=LEFT(A1,1)*1
The '*1' will return the first number in the string as a true number as
opposed to text that the LEFT function would normally return, then sort the
two columns by column B,
Regards,
Alan.
"maacmaac" wrote in
message ...

I have following list in Excel:
54
6A
34
5T
4X
67

When a do Data|Sort|Ascending the list looks like this:
34
54
67
4X
5T
6A

I need the list to sort like this:
34
4X
54
5T
67
6A

I have tried a half dozen ways to sort including formatting the cells,
but nothing is working. Any help would be great. Thanks.


--
maacmaac
------------------------------------------------------------------------
maacmaac's Profile:
http://www.excelforum.com/member.php...fo&userid=2959
View this thread: http://www.excelforum.com/showthread...hreadid=506446