Sort - alphanumeric.
You need to extract the numbers into ahelp column and sort by the help
column, if indeed you only have a letter in the string you can use
=--RIGHT(A1,LEN(A1)-1)
copy down, select both columns and sort by the help column
--
Regards,
Peo Sjoblom
"Brad" wrote in message
...
I have numerical data with alphabetical prefixes in a column.
This is what I get when I sort:
C1,C10,C2,C8,R1,R10,R11,R2
This is what I want when I sort:
C1,C2,C8,C10,R1,R2,R10,R11.
How can I do this?
|