Sort mixed numbers/letters
 

How can I sort by a row of numbers with mixed formats? I have numbers such
as 1, 2, 3 and 10, 22, 27 and 11-A, 20-D, 34-D etc. Currently, no matter how
I format the cells, they sort by first number, then second, then the numbers
with letters (1, 10, 2, 22, 27, 11-A, 20-D etc.). I can't seem to find a way
to get the column to sort by the actual value (1, 2, 3, 10, 11-A, 22, etc.)
Please...any help you can give me. Thank you.

Sort mixed numbers/letters
 

See your other post

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"V-ger" wrote in message
...
How can I sort by a row of numbers with mixed formats? I have numbers
such
as 1, 2, 3 and 10, 22, 27 and 11-A, 20-D, 34-D etc. Currently, no matter
how
I format the cells, they sort by first number, then second, then the
numbers
with letters (1, 10, 2, 22, 27, 11-A, 20-D etc.). I can't seem to find a
way
to get the column to sort by the actual value (1, 2, 3, 10, 11-A, 22,
etc.)
Please...any help you can give me. Thank you.