William,

Try a helper column (a spare column for sorting purposes only, hidden
if required) with something like:

=IF(ISERROR(A1+0),1,0)

and formula copy to the end of your data.
Then sort over helper (ascending) and column A (ascending)



William Wrote:
I want to sort data that contains numbers and letters. I have tried
formatting the row as text and it still does not work. Everytime I
sort it
doesn't list the entires in order but rather the numbers first then
the
numbers with letters next. Here is what im trying to sort:

1227
1244
~~
1494
1572
1258-A
1258-B
~~
1403-E
1403-G

Can anyone Help!


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=482979