Posted by Brian on February 11, 2002 4:39 AM
I have several collumns of alphanumeric data such as..
My problem is when I do a sort Excel seems to be ignoring the full number and just ordering by the first number.ie A111 comes before A2 or A20 for that matter what I need is a way to sort it correctly so it would go A1-A900 in numeric order.
I cannot add preceding zeros to them as this is not the format I require.
Any assistance would be appreciated.