sorting cells that contain spaces and hyphens

[Guest]

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?

 

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

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

 

[Stephen]

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