Text and numbers that I want sorted numerically

Hi. I have a problem I hope someone can help me solve. Can I somehow sort the following numerically?
So they instead of 1, 10, 11 etc. they are 1,2,3 etc.

The info is in one cell.

Thanks!

MFM019_1_Split End_Will Fitzwater
MFM019_10_Humanoid_Danny Widdicombe
MFM019_11_From Hell_Peter Christie
MFM019_12_From Hell_Peter Christie
MFM019_13_Ice Maiden_Will Fitzwater
MFM019_14_Ice Maiden_Will Fitzwater
MFM019_15_Low_Brad Wall
MFM019_16_Low_Brad Wall
MFM019_17_Moody_Luke Adams
MFM019_18_Moody_Luke Adams
MFM019_19_Under Craft_Peter Christie
MFM019_2_Split End_Will Fitzwater
MFM019_20_Under Craft_Peter Christie
MFM019_21_In My Head_Peter Christie
MFM019_22_In My Head_Peter Christie
MFM019_23_Wires_Tim Pasmore
MFM019_24_Wires_Tim Pasmore
MFM019_25_Factory Slave_Ross McLennan
MFM019_26_Factory Slave_Ross McLennan
MFM019_27_Hear The Silence_Peter Christie
MFM019_28_Hear The Silence_Peter Christie
MFM019_29_Lost Lust_Peter Christie
MFM019_3_Broken Click_Peter Christie
MFM019_30_Lost Lust_Peter Christie
MFM019_31_Pulp_Peter Christie
MFM019_32_Pulp_Peter Christie
MFM019_33_Rain Parade_Peter Christie
MFM019_34_Rain Parade_Peter Christie
MFM019_35_Abyss_Peter Christie
MFM019_36_Abyss_Peter Christie
MFM019_37_Light Flickers_Danny Widdicombe
MFM019_38_Light Flickers_Danny Widdicombe
MFM019_39_Old Man Star_Luke Adams
MFM019_4_Broken Click_Peter Christie
MFM019_40_Old Man Star_Luke Adams
MFM019_41_Extreme Makeover_Will Fitzwater
MFM019_42_Extreme Makeover_Will Fitzwater
MFM019_43_Darkness Visible_Rachael Selleck
MFM019_44_Darkness Visible_Rachael Selleck
MFM019_45_Secret Liason_Peter Christie
MFM019_46_Secret Liason_Peter Christie
MFM019_47_The Prophet_Mikal Laguerre
MFM019_48_The Prophet_Mikal Laguerre
MFM019_49_Traffic Grind_Ross McLennan
MFM019_5_Bound_Peter Christie
MFM019_50_Traffic Grind_Ross McLennan
MFM019_6_Bound_Peter Christie
MFM019_7_Cut Cold_Peter Christie
MFM019_8_Cut Cold_Peter Christie
MFM019_9_Humanoid_Danny Widdicombe

you could use a helper column and sort based on that, helper formula would be (assuming this is in Col B):

=INT(MID(B1,FIND("_",B1)+1,FIND("_",MID(B1,8,100))-1))

if you add another column before A (thus making your data Column B) my formula will give you just the numbers, you can then use that column as your sort column.

you put the formula in Column A (Starting At A1) and copy down, i would then replace A1 with somethign more approperiate of a header.

try starting in A2

=INT(MID(B2,FIND("_",B2)+1,FIND("_",MID(B2,8,100))-1))

eh, mac... it could be, but i wouldnt think so. are you able to use these functions alone?

INT,MID,FIND

@ dgagnons formula

sort.xlsx