Hello

Input:
C1, C2
C4
C10
C5
C56,C78
D2
C658
C101
D1
C6


all entries are unique (LNNN L-letter, NNN-number; there is only one combination LNNN in database e.g. there is no other entry which contain C10 for example)

Desired output
C1, C2
C4
C5
C6
C56, C78
C658
C101
D1
D2

What Excel does :
C1, C2
C10
C101
C4
C5
C56, C78
C6
C658
D1
D2



Desired sort criteria : sort by first character : first character is a letter so sort alphabetically from A to Z;
if there are more rows which have identical first letter, then sort by second character which is a number;
sort these entries as numbers , treat them as numbers not as letters.; e.g. 1,2,3..., 10, 11..., 20... not 1, 10, 100, 2, 20, 200 ....

Can anyone help me with some VBA code ?
I have several columns like that one, so a solution that can accept multiple columns would be even better
The columns have variable length

Thank you