| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting cells that contain spaces and hyphens
Can anyone tell how I can sort a list where the cell contents contain spaces
and hyphens? For example I have a list of part numbers coming out in the following order: 0200 .2285-001-0-00 0200 .5126-006-0-00 0200 .5305-001-0-00 0200 .3200-006-0-00 0200 .2850-006-0-00 I need the list to come out like: 0200 .2285-001-0-00 0200 .2850-006-0-00 0200 .3200-006-0-00 0200 .5126-006-0-00 0200 .5305-001-0-00 Any way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting cells that contain spaces and hyphens
On Oct 15, 10:10 am, amaries
wrote: Can anyone tell how I can sort a list where the cell contents contain spaces and hyphens? For example I have a list of part numbers coming out in the following order: 0200 .2285-001-0-00 0200 .5126-006-0-00 0200 .5305-001-0-00 0200 .3200-006-0-00 0200 .2850-006-0-00 I need the list to come out like: 0200 .2285-001-0-00 0200 .2850-006-0-00 0200 .3200-006-0-00 0200 .5126-006-0-00 0200 .5305-001-0-00 Any way to do this? in a helper column, use something like this and sort on that column. =SUBSTITUTE(SUBSTITUTE(A2,"-","")," ","") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting cells that contain spaces and hyphens
"amaries" wrote in message
... Can anyone tell how I can sort a list where the cell contents contain spaces and hyphens? For example I have a list of part numbers coming out in the following order: 0200 .2285-001-0-00 0200 .5126-006-0-00 0200 .5305-001-0-00 0200 .3200-006-0-00 0200 .2850-006-0-00 I need the list to come out like: 0200 .2285-001-0-00 0200 .2850-006-0-00 0200 .3200-006-0-00 0200 .5126-006-0-00 0200 .5305-001-0-00 Any way to do this? Unless I've misunderstood, the ordinary Excel sort function will do this by default. Try it, and post back with details if it doesn't do what you want. Stephen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| How do I count cells with text but ignore cells with spaces? | Excel Discussion (Misc queries) | |||
| Spaces in cells | Excel Worksheet Functions | |||
| Formatting cells for decimals and hyphens | Excel Discussion (Misc queries) | |||
| Does XL2K have "hard hyphens" (non-break hyphens)? | Excel Discussion (Misc queries) | |||
Hybrid Mode
