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

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




"dean d." <dean wrote in message
...
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