Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Numbers that have Text
I need to sort like this
1 5 90 90a 90b 100 170a 170b instead of 1 5 90 100 90a 90b 170a 170b I found a message from 2006 that said to do this: "I'd convert the column to Text. (Data-Text to Columns...) Then, sort, making sure to check "Sort number and numbers stored as text separately." I did what was suggested and got this: 1 100 170a 170b 5 90 90a 90b So, how do I get it to sort the way I want? (the numbers go up into the 1000's) -- Ginger Kohler |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting numbers and numbers that contain text in excel | Excel Discussion (Misc queries) | |||
sorting text with numbers | Excel Worksheet Functions | |||
Sorting numbers with text | New Users to Excel | |||
Help sorting text as numbers | Excel Worksheet Functions | |||
SORTING TEXT AND NUMBERS | Excel Worksheet Functions |