If that's the case you would need a help column where you parse the numbers,
then select both columns and sort by the help column, are there always 3
letters followed by the numbers? If so you could use


=--MID(A2,4,15)

if not you can use


=--MID(A2,MATCH(TRUE,ISNUMBER(--MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),0),15)

entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom


"Mike W" wrote in message
...
I have data entries in a column as follows: ABC123, DFR234, TRE456 and so
on. What I need to do is to sort this column by the numbers and not
alphabetically but retain the letters in the sorted list.

Help would be appreciated.

Mike