| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with sorting numbers with text suffix
Need help sorting numeric. Currently sorts:
492947 494537S 49355 495234 5001H 690190 Need 5001H to be at the beginning, then 49355, then 492947 and so on. Cell, format, column, set as "text" due to last character possibly being alpha. Help please. Thanks. Jackson |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with sorting numbers with text suffix
Take a look at Jim Cone's fine commercial add-in called "Special Sort".
It's available at http://www.realezsites.com/bus/primi...e/products.php Vaya con Dios, Chuck, CABGx3 "Jackson" wrote in message ... Need help sorting numeric. Currently sorts: 492947 494537S 49355 495234 5001H 690190 Need 5001H to be at the beginning, then 49355, then 492947 and so on. Cell, format, column, set as "text" due to last character possibly being alpha. Help please. Thanks. Jackson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with sorting numbers with text suffix
Isn't there an a-z plus z-a sort in the data sort heading - believe when
working on an .xls file which was sorted in the alpha (a-z), the numbers came first and then the alpha text - this depends on the column chosen as your first (or main column) in the sort criteria box. Hope this helps. "Jackson" wrote: Need help sorting numeric. Currently sorts: 492947 494537S 49355 495234 5001H 690190 Need 5001H to be at the beginning, then 49355, then 492947 and so on. Cell, format, column, set as "text" due to last character possibly being alpha. Help please. Thanks. Jackson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add a suffix to a whole column of different part numbers? | Excel Worksheet Functions | |||
| Sorting numbers as Text | New Users to Excel | |||
| SORTING TEXT AND NUMBERS | Excel Worksheet Functions | |||
| Sorting Numbers w/Aplha Suffix | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Hybrid Mode
