-
Sorting based on letter, and then on number
Hi all,
I have a column of values with each row in that column composed of 1 to 3 letters, and then a number, with the length of this number ranging from 1 to 5 digits.
The letters all belong in a group, (e.g. AA, B, C, CB, J, T) and so need to be grouped together when sorting, and the numbers then are to increase sequentially.
Below is a table with my intended input and desired output.
Input |
Output |
AA1 |
AA1 |
T4 |
B5 |
T1 |
C27 |
B5 |
CB5 |
J23 |
CB12 |
J19 |
J19 |
C27 |
J23 |
CB12 |
T1 |
CB5 |
T4 |
Is this something that can be achieved with VBA?
If so, any guidance would be greatly appreciated
Cheers,
enjam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules