Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting numbers with hyphens in excel
I am trying to sort a list of numbers, some of which contain hyphens. For
example I want to sort "65,66,66-1,67-1,68,69". Excel sorts it out as "65,66,68,69,66-1,67-1". What I want it to give me is "65,66,66-1,67-1,68,69". Any ideas on how to do this in a simple manner? I have had some ideas thrown at me but they are all rather involved and I would like to be able to sort in this manner often. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting numbers with hyphens in excel
First, convert all your data to text. Various ways of doing this, a quick
way is to use the formula: =TEXT(A1,"@") and then do a copy, paste special - values Next, select your data, sort, ascending, and choose "sort numbers as text" option. Otherwise, XL will sort all the numbers first, and then all the text strings. -- Best Regards, Luke M "mb-76" wrote in message ... I am trying to sort a list of numbers, some of which contain hyphens. For example I want to sort "65,66,66-1,67-1,68,69". Excel sorts it out as "65,66,68,69,66-1,67-1". What I want it to give me is "65,66,66-1,67-1,68,69". Any ideas on how to do this in a simple manner? I have had some ideas thrown at me but they are all rather involved and I would like to be able to sort in this manner often. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting cells that contain spaces and hyphens | Excel Discussion (Misc queries) | |||
numbers contain hyphens to dates | Excel Worksheet Functions | |||
how do i remove hyphens from between numbers | Excel Worksheet Functions | |||
How do i remove the hyphens between numbers without having to edi | Excel Discussion (Misc queries) | |||
Does XL2K have "hard hyphens" (non-break hyphens)? | Excel Discussion (Misc queries) |