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