Thanks. Do I copy and paste special, as instructed in Ken's previous email?
Also, do I choose A) Sort anything that looks like a number as a number, or
B) Sort numbers and numbers stored as text seperately? I'm a real novice.
Thanks for your help.

"Bryan Hessey" wrote:


Try

=IF(ISERROR(FIND("-",A1)),TEXT(A1,"000000"),TEXT(LEFT(A1,(FIND("-",A1)-1)),"000000")&MID(A1,(FIND("-",A1)),99))

where "000000" needs to be long enough to cover your largest number,
and all alpha addons need to be after a '-' character.

V-ger Wrote:
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!


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