Hi, I have few rows of data
<tbody>
</tbody>
Expected Result
<tbody>
</tbody>
Bottom Line I need to sort it as C1,C2,C3,.....C100,c101.. alphabet's first then numbers 1,2,3, sorting alpha numerically
Using build in SORT function I get C1,C100,C101.... I have like 500 rows as such, is there any way I could accomplish this with macro's?
COL A | COL B |
C1 | 0.2 |
C100 | 0.3 |
C101 | 0.4 |
C2 | 0.6 |
C201 | 0.7 |
C202 | 0.8 |
R3 | 0.9 |
R301 | 1 |
R302 | 2 |
<tbody>
</tbody>
Expected Result
COL A | COL B |
C1 | 0.2 |
C2 | 0.6 |
C3 | 0.9 |
C100 | 0.3 |
C101 | 0.4 |
C200 | 0.6 |
C201 | 0.7 |
C202 | 0.8 |
R3 | 0.9 |
<tbody>
</tbody>
Bottom Line I need to sort it as C1,C2,C3,.....C100,c101.. alphabet's first then numbers 1,2,3, sorting alpha numerically
Using build in SORT function I get C1,C100,C101.... I have like 500 rows as such, is there any way I could accomplish this with macro's?