Ken, Thank you so much. The numbers do vary in number of digits. I really
appreciate all your help with this problem, you were terrific. I installed
and used the add-in sent by Jim and it is working well so far. It did solve
my immediate issue. Keep up the good work. I have so much to learn about
Excel, and I am encouraged by your patient help. - V-ger

"Ken Wright" wrote:

Note though, that this assumes your data is no more than double digit as per
your example data. Any more than that and you need a more comprehensive
formula.

Regards
Ken................

"Ken Wright" wrote in message
...
OK, other than perhaps using Jims addin, the only way I get there without
extra columns is to make all your digits double digit, using

=TEXT(A2,"00")

and copy down. Won't affect the text entries but will convert numerics to
double digit text. Format doesn't matter.

This should sort the way you want it.

Yes you were correct on last note:-

= " " & A 2 but without the spaces

Regards
Ken....................


"Ken Wright" wrote in message
...
Ahhh - sorry, didn't read the post correctly - bear with me.

Regards
Ken..................

"V-ger" wrote in message
...
Still not sorting correctly. What am I doing wrong? It's better, but
the 3
still comes after the 22-A. Two issues...first, does the cell format
need to
be "General" or "Number" or what? Second, when I type the formula you
wrote
below it didn't work, but when I copied it from your post and pasted it
in,
it worked as a formula - is it equals, quote, quote, ampersand,
cell-address-of-the-cell-to-the-left? Thank you so much!

"Ken Wright" wrote:

Convert everything to text. Assuming your data is in Col A, then in
Col B
use

=""&A2 and copy down. Then copy and paste special as values and delete
Col
A. Now sort on your data as you wish.

--
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.