Hi there,

New to the forum, and pretty much new to Excel. I have several workbooks (lists) containing variable length alphanumerical data I need to sort in a different way than Excel tries to entice me with. Example of the data sorted out by Excel:

SWC-0000
SWC-0007
SWC-00094
SWC-00126
SWC-0013
SWC-0015

I need the data sorted as follows:

SWC-0000
SWC-0007
SWC-0013
SWC-0015
SWC-00094
SWC-00126

Above example is just the beginning of a list containing a few thousands rows. All my lists starts with letters. Although some have 3, 4 or up to 6 letters. Then a dash, then numbers, some having 3, 4, 5 or 6 of them. What I'd like to have Excel to do, is sort all the ones with let's say 3 numbers first, then the ones with 4, etc.

Any help on this?