Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I posted this yesterday and got no responses. Is there someone who could
help me? _____________________________________________ 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 | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting alphanumeric | Excel Discussion (Misc queries) | |||
Sorting List of Numbers | Excel Discussion (Misc queries) | |||
Does font color affect sorting a list in Excel? | Excel Worksheet Functions | |||
Sorting for specific words/numbers in a list | Excel Worksheet Functions | |||
Sorting a list with subtotals | Excel Worksheet Functions |