VBA BubbleSort Worksheet Alphanumerically

[decadence]

Hi, Is it possible to sort a worksheet Alphanumerically by the cell values in a column without a helper column? I would Like to put a column of alphanumeric data into a List then Alphanumeric sort that List Alphanumerically, Then use that sorted List to sort the worksheet of data if that makes sense, Can anyone help with this please

Key factors:
The alphanumeric data may contain dashes and/or underscores i.e. C1_1-1, C215-2_1, DTR3-3, DTR43_21, J5_J1-1, QR10_Q1_3
The range of alphanumeric data is varied rows and up to 10 columns of data
There will always be a header to reference from which also may have a varied name
Needs to be sorted by letter first then by number

Example
From this

C1	Something	Something	Something	Something
C10	Something Else	Something Else	Something Else	Something Else
C3	Info	Info	Info	Info
B2	Other	Other	Other	Other

To this

B2	Other	Other	Other	Other
C1	Something	Something	Something	Something
C3	Info	Info	Info	Info
C10	Something Else	Something Else	Something Else	Something Else

 

[Peter_SSs]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

The alphanumeric data may contain dashes and/or underscores i.e. C1_1-1, C215-2_1, DTR3-3, DTR43_21, J5_J1-1, QR10_Q1_3

.. but none of your sample data is like this so it is unclear just how you would want the sorting of such data to work.

 

[decadence]

I am currently using 2007/2010 but will shortly be going to 2013/2016

The comma delimited example was meant to represent examples of the data I may get, not as a comma delimited string.

The issue I face is that my data can vary and the normal sort does not sort Alphanumerically without using helper columns which I am trying to avoid.

To clarify.... my data would look something like this below

QR10_Q1_3	Something	Something	Something	Something
C10	Something Else	Something Else	Something Else	Something Else
DTR3-3	Info	Info	Info	Info
C215-2_1	Other	Other	Other	Other

After Sorting

C10	Something Else	Something Else	Something Else	Something Else
C215-2_1	Other	Other	Other	Other
DTR3-3	Info	Info	Info	Info
QR10_Q1_3	Something	Something	Something	Something

 

[Peter_SSs]

The comma delimited example was meant to represent examples of the data I may get, not as a comma delimited string.

Yes, I understood that.
The issue was that your original examples did not include any values with hyphens or underscores.

Your latest examples do, but still shed no light on what the rules for sorting actually are. For example, what order should these values come in and why?
Can you put into words what the sorting rules are?

decadence 2020-06-17 1.xlsm
	A
1	C215-2_1
2	C215_2-1
3	C2152_1
4	C215_D
5	C2-15_C
6	C2-15_X
Sheet2

 

[decadence]

So currently I have a helper column that helps sort by split out cell values to sort all the rows by the helper columns like below, the only rule is to sort by the hyphen first then by Underscore if the cell contains both

Sort 1st	Sort 2nd	Sort 3rd	Sort 4th	Sort 5th	Sort 6th	Sort 7th
QR	10	_	Q	1	_	3

Essentially I don't want to use the helper column and contain this sort method into a bubble sort, so ideally get the range of cells, put them into an array, split the array then sort the split array and implement that sorted array to sort the rows