Sorting data that has multiple formats

GORAGUY

New Member
Joined
Jun 15, 2012
Messages
2
I have lists of products that I want to sort, but all the skus are in different formats, some letter, numbers, spaces, symbols and mixes of all.
Example:
01107919
CE-4128B9
RED-BRIC889
1124
14100119020-E
86TR
ECO CUP22OZ/1000
1418909888783301

I would like to organize them by the order of the numbers, letters and symbols, not the value of the numbers.
Example:
01107919
1124
14100119020-E
1418909888783301
86TR
CE-4128B9
ECO CUP22OZ/1000
RED-BRIC889

I have tried formatting and different sorting options but there's a dent in the wall and my forehead is getting bruised from all of the banging.
I am hoping that an Excel Guru will help me out and stop me from banging my head against the wall.
I am a self taught excel user. I'm a hack. So use small words and talk slowly. :)
:eek::confused:
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
When i choose sort I get this result. (excel 2007 => data => sort)

1107919
1124
1,41891E+15
14100119020-E
86TR
CE-4128B9
ECO CUP22OZ/1000
RED-BRIC889

<COLGROUP><COL style="WIDTH: 505pt; mso-width-source: userset; mso-width-alt: 24612" width=673><TBODY>
</TBODY>
 
Upvote 0
Ok, but it mixed up the 3rd and 4th items. 141891 should be after 14100119020 to work for what I need.
thank you.
 
Upvote 0

Forum statistics

Threads
1,219,162
Messages
6,146,659
Members
450,706
Latest member
LGVBPP

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