I have a list of numbers in a column as follows:
2
55
37
8
22, 17
3, 12, 47
When I sort with my macro I get:
2
8
37
55
3, 12, 47
22, 17
What I want is:
2
3, 12, 47
8
22, 17
37
55
Is there a way in vba to have it sort the list using only the number in front of the first comma?
Thank you.
Bookmarks