Hi,

This would work for the first letter of the text only. Say your data are in
column A, put This in B1 and fill down

=IF(CODE(LOWER(A1))<=57,CODE(A1),CODE(A1)-97)

Select both columns and sort on column B ascending. You can hide column B if
you want.


Mike

"teh_chucksta" wrote:

how can I sort a column with numbers and text in descending order where the
text falls to the bottom and not the top?

thanks,
charlie