Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting alphanumeric
I would like to sort some text which is formatted in column one as:
1' 100 1000' 2 2' and so on. Any number that does not have an "'" at the end should come before any number that does and all the 1s, 2s, 3s, etc. should be grouped together. Is this possible? The result would look like: 1 100 1000' 2 2' Boy, would I appreciate some help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alphanumeric sorting | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel | |||
sorting question | Excel Discussion (Misc queries) |