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