SORTING IN EXCEL 2003
Really, nothing is broken.
XL is sorting your data as Text, not as numbers.
If your data is exactly like your example, you can extract the ending
numbers into an adjoining, "helper" column, convert them to XL recognized
numbers, and then sort both columns together, using the "helper" column as
the sort key, and then finally delete that helper column.
With data in Column A, starting in A1, enter this formula into B1:
=--RIGHT(A1,LEN(A1)-3)
Copy down as needed, then sort *both* columns, using B as the key.
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"KAT" wrote in message
...
In hopes that someone can help me:
I am trying to sort in a column the following in "numerical" order:
A2N1, A2N5, A2N10 (In this order)
It keeps sorting as follows: A2N1, A2N10, A2N5
Is there a way to fix this?
many thanks!
|