Help with complex string sorting in Excel

Hope someone can help me. So I have some data entries that come in at : 'Port 1 Magnitude Index:0' 'Port 1 Magnitude Index:1' 'Port 1 Magnitude Index:2' 'Port 1 Phase Index:0' 'Port 1 Phase Ind...