Sorting

[Nine Zero]

Hello,

I have a list of the following

xyz1

xyz2

xyz4

xyz11

xyz3

<tbody>
</tbody>

I need to sort them but Excel will only sort them if i have the same amount of digits in the number like say

xyz01

xyz02

xyz03

xyz04

xyz11

<tbody>
</tbody>

is there a way to sort them without having to do that so that i get from my current to my expected

Current Result	Expected Result
xyz1	xyz1
xyz11	xyz2
xyz2	xyz3
xyz3	xyz4
xyz4	xyz11

<tbody>
</tbody>

 

[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
1	xyz1	xyz001
2	xyz2	xyz002
3	xyz3	xyz003
4	xyz4	xyz004
5	xyz11	xyz011

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 =LEFT(A1,3)&TEXT(MID(A1,4,9)+0,"000") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>