D dean d. May 6, 2008 #1 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
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 May 6, 2008 #2 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
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
