How to sort strings from specific position?

[lalaluye]

For example I have several text strings

text_string_126778
text_string_123456
text_string_234567

I want to sort from position 15 to position 16

Result would be
text_string_123456
text_string_234567
text_string_126778

So other than position 15 and 16, the rest I dont care

xxxxxxxxxxxxx45x
xxxxxxxxxxxxx56x
xxxxxxxxxxxxx77x

 

[mrmmickle1]

Just use the mid function and then sort from the helper column:

EXAMPLE:

Excel 2012
	A	B
1	text_string_123456	45
2	text_string_234567	56
3	text_string_126778	77
4	text_string_126779	77
Sheet3

Cell Formulas
Range	Formula
B1	=MID(A1,16,2)
B2	=MID(A2,16,2)
B3	=MID(A3,16,2)
B4	=MID(A4,16,2)

 

[lalaluye]

Do you know of a way to write this in VBA?

If I do

Variable = Mid(A1, 16, 2)
Can Variable be assigned as an integer? Because I want to compare two variables (Numbers extracted from string) and see which one is smaller

 

[Rick Rothstein]

For example I have several text strings

text_string_126778
text_string_123456
text_string_234567

I want to sort from position 15 to position 16

Result would be
text_string_123456
text_string_234567
text_string_126778

So other than position 15 and 16, the rest I dont care

xxxxxxxxxxxxx45x
xxxxxxxxxxxxx56x
xxxxxxxxxxxxx77x

Is the "text_string_" part of your examples always going to be same length as shown so that the numbers you want to sort by will always be in position 15 and 16 for every cell value? If not, is the number part of your cell values always 6 digits long and you want to start at the 4th digit from the end?