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