sorting columns

D

dean d.

i want to srt a column in the following order a-1,a-2,a-3 and so on. as of
now excel is sorting a-1 ,a-10 a-11 and so on
 
P

Peo Sjoblom

You would need a help column for that, if the numbers are always after the
hyphen then you could use

=--TRIM(MID(A2,FIND("-",A2)+1,255))


copy down then sort ascending on the help column


--


Regards,


Peo Sjoblom
 
Top