Sorting

Nine Zero

Well-known Member
Joined
Mar 10, 2016
Messages
625
Hello,

I have a list of the following

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]xyz1
[/TD]
[/TR]
[TR]
[TD]xyz2
[/TD]
[/TR]
[TR]
[TD]xyz4
[/TD]
[/TR]
[TR]
[TD]xyz11
[/TD]
[/TR]
[TR]
[TD]xyz3
[/TD]
[/TR]
</tbody>[/TABLE]

I need to sort them but Excel will only sort them if i have the same amount of digits in the number like say
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]xyz01
[/TD]
[/TR]
[TR]
[TD]xyz02
[/TD]
[/TR]
[TR]
[TD]xyz03
[/TD]
[/TR]
[TR]
[TD]xyz04
[/TD]
[/TR]
[TR]
[TD]xyz11
[/TD]
[/TR]
</tbody>[/TABLE]

is there a way to sort them without having to do that so that i get from my current to my expected
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Current Result
[/TD]
[TD]Expected Result
[/TD]
[/TR]
[TR]
[TD]xyz1
[/TD]
[TD]xyz1
[/TD]
[/TR]
[TR]
[TD]xyz11
[/TD]
[TD]xyz2
[/TD]
[/TR]
[TR]
[TD]xyz2
[/TD]
[TD]xyz3
[/TD]
[/TR]
[TR]
[TD]xyz3
[/TD]
[TD]xyz4
[/TD]
[/TR]
[TR]
[TD]xyz4
[/TD]
[TD]xyz11
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Depending on your data, you could create a work column with your data normalized, then sort by that column.

AB
xyz1xyz001
xyz2xyz002
xyz3xyz003
xyz4xyz004
xyz11xyz011

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

</tbody>
Sheet1

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B1[/TH]
[TD="align: left"]=LEFT(A1,3)&TEXT(MID(A1,4,9)+0,"000")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,106
Members
452,302
Latest member
TaMere

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