sorting cells that contain spaces and hyphens

A

amaries

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?
 
J

JW

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?
Click to expand...

in a helper column, use something like this and sort on that column.
=SUBSTITUTE(SUBSTITUTE(A2,"-","")," ","")
 
S

Stephen

amaries said:
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?
Click to expand...

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
 
Top