Sort list
"2039B" is text, and any text is treated by Excel as being greater than the
largest real number, that's why. To sort these like real numbers, use a
helper col,
eg in B1, copied down: =IF(A1="","",IF(ISNUMBER(A1),A1,LEFT(A1,4)+0))
Then sort both cols A and B by col B, ascending, and you should get the
desired sort in col A. Success? hit YES below
--
Max
Singapore
---
"janey" wrote:
I have a table which I need to sort, e.g.:
2000
2039B
2026
2167
2239
2242
When I run Sort, I get
2000
2026
2167
2239
2242
2039B
Why does 2039B come at the bottom rather than between 2026 and 2167?
|