Sort Problem looking for numerical digits

jstrong

New Member
Joined
Jan 21, 2005
Messages
1
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-100 MMP 501400AD
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-1012 MMP 559100AD
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?

Thank you so much for your reply!
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
Joined
Jul 21, 2002
Messages
73,092
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.
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top