Sorting

[Nine Zero]

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]

 

[Dan Waterloo]

No.

 

[Eric W]

Depending on your data, you could create a work column with your data normalized, then sort by that column.

	A	B
xyz1	xyz001
xyz2	xyz002
xyz3	xyz003
xyz4	xyz004
xyz11	xyz011

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