Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to sort a text field that has both numbers and alphas in it, I am
not able to get it to sort right at all. Listed is how it is sorting followed by how it needs to be. Any help would be appreciated. This is how it is sorting: 1002086-A 1002-G 1003923-FB 1003-A 1003-G 1005243-01 1005-G 20-A I need it to sort: 20-A 1002-G 1003-A 1003-G 1005-G 1002086-A 1003923-FB 1005243-01 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column matching - sorting. Fairly hard problem, I think. | Excel Discussion (Misc queries) | |||
Problem sorting cells containing hyperlinks | Excel Worksheet Functions | |||
Date sorting problem | Excel Discussion (Misc queries) | |||
An instant sorting problem | Excel Worksheet Functions | |||
Sorting problem | Excel Worksheet Functions |