Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anyone know why Microsoft would ignore hyphens and apostrophes in the
sort? The help says it was designed to be consistant with Windows. Our company uses hyphens in certain positions of the product number, so now if we sort by product number, it ignores the hyphens and screws up the list. Any suggestions for getting around this and have a sort use the hyphens? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting numbers with hyphens in excel | Excel Discussion (Misc queries) | |||
Removing text between hyphens and removing the hyphens | Excel Discussion (Misc queries) | |||
Using two hyphens in front of an Excel function. | Excel Worksheet Functions | |||
Excel sort ( exclude letters include hyphens)? | Excel Worksheet Functions | |||
Does XL2K have "hard hyphens" (non-break hyphens)? | Excel Discussion (Misc queries) |