# Sort Problem looking for numerical digits

#### jstrong

##### New Member
I am having trouble sorting the following colmn A. I have 3 columns below however they are scrunched together. I'm looking to sort the left column (A) in numerical order for example from 204-100, 204-101, 204-102 and so on.
Because I have some that are 4 digits after the dash I'm getting is the following.

A B C
Number Customer Part Number
204-095 MMP VE353-103-03165/14 (IB)
204-096 MMP 558800AT
204-097 MMP 558700AT
204-098 MMP 558600AT
204-099 MMP 501600AN
204-1000 Swiss-Tech 149324P
204-1001 MMP 503500AF
204-1002 MMP 558000AN
204-1003 unused unused
204-1004 MMP 503500AF
204-1005 MMP 503500AF
204-1006 MMP 503500AF
204-1007 MMP 503500AF
204-1008 MMP 503500AF
204-1009 MMP 503500AF
204-101 MMP 503500AF
204-1010 MMP 503500AF
204-1011 MMP 503500AF
204-1013 MMP VE353-100 & 102, 101 & 103
204-1014 MMP 558000an
204-1015 MMP 561000 & 561200
204-1016 MMP 300600AE
204-1017 MMP 558800?
204-1018 MMP 558300AN
204-1019 Swiss-Tech 149324P
204-102 MMP 503500AF
204-1020 MMP VE398-01
204-1021 MMP 558300AN
204-1022 MMP 558300AN

I have attempted formatting the column and re-sorting?? I have read reformatting does not affect existing data? Does anyone have a suggestion?

P.S. I am assuming that sorting will carry all data on adjacent columns?

Jay Strong

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### Andrew Poulsom

##### MrExcel MVP
Copy the Numbers to a spare column. Select them all and Replace - with nothing to convert them to real numbers. Then sort all 4 columns on that column.

Replies
6
Views
178
Replies
1
Views
196
Replies
4
Views
331
Replies
3
Views
550
Replies
1
Views
310

1,130,118
Messages
5,640,216
Members
417,131
Latest member
Seanr19871

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back