Bryan, Thanks for your help. I decided to use the add-in, it's just two
clicks. But please answer a question - since I will use your formula to learn
about formulas...when I tried it, I substituted A1 for the actual first bit
of information that I wanted to sort, which was A5. Was that correct? Thank
you.

"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