Sort by text in the middle of a string

I have a data-set 64 column wide and 121 rows deep. The headers are made from a combination of 4-R’s (R0, R15, R30 and R45), 4-H’s (H6, H7, H8 and H9) and 4-D’s (D2, D4, D6 and D8), resulting in text strings such as: R0-H6-D2, R15-H6-D2...etc. (see picture attached). : I want to sort my 64-columns by ‘H’ such that:
-1st 16 columns will have H6 as the middle value
-2nd 16 columns will have H7 as the middle value
-3rd 16 columns will have H8 as the middle value
-And the last 16 will have H9 as the middle value

Any help is much appreciated!

I would suggest making a helper row to extract the H6/H7/H8/H9 and then sort by the helper row.

=mid(A1,find("H",A1,1),2)

should do it.

Originally Posted by yudlugar

I would suggest making a helper row to extract the H6/H7/H8/H9 and then sort by the helper row.

=mid(A1,find("H",A1,1),2)

should do it.

yudluga,
That did it beautifully. Thanks a lot!