sorting - how to sort alphanumeric values in excel in a specific format i desire other than the one done by default -
i have values in excel column 1 6 5 2 3 1a 3b1 3b4 3b3 2c 2d. when sorted result 1 2 3 5 6 1a 2c 2d 3b1 3b3 3b4. supposed 1 1a 2 2c 2d 3 3b1 3b3 3b4 5 6. how desired result?
with data in column a, in b1 insert:
=a1 & char(1)
and copy down. sort cols a & b b:
afterwards, column b can cleared.
Comments
Post a Comment