Sorting Problem

[fatboyjimbob]

Hi,

I need to sort the following
<table x:str="" style="border-collapse: collapse; width: 96pt;" width="128" border="0" cellpadding="0" cellspacing="0"><col style="width: 96pt;" width="128"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; width: 96pt;" x:str="CPPI78 " width="128" height="17">CPPI78 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI79 " height="17">CPPI79 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI8 " height="17">CPPI8 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI80 " height="17">CPPI80 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI81 " height="17">CPPI81 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI82 " height="17">CPPI82 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI83 " height="17">CPPI83 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI84 " height="17">CPPI84 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI85 " height="17">CPPI85 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI86 " height="17">CPPI86 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI87 " height="17">CPPI87 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI88 " height="17">CPPI88 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI89 " height="17">CPPI89 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI9 " height="17">CPPI9 </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:str="CPPI90 " height="17">CPPI90 </td> </tr> </tbody></table>
I don't use excel often, so any help appreciated.

Thanks

 

[Legacy 14611]

Hi,

Isn't there a sort button in your Excel menus, at top of page?

 

[fatboyjimbob]

well i need CPPI9 not to follow CPPI89