sorting text from one cell into 3 other cells based on text criteria

Hello! I am new to this forum and I really need some help! I am trying to take text from one column and seperate it into three colums...the text is grouped in one cell and shown as such, " NS1, NP3, HE2" and so forth. My difficulty is that the 3-letter text entires are of several possibilities, the possible entries on any one cell will be any possible combo of the 3 following groups: NS1, NS2, NS3, LS1, LS2, LS3, MS1, MS2, MS3, HS1, HS2, HS3 (THE "S's") , NP1, NP2, NP3, LP1, LP2, LP3, MP1, MP2, MP3, HP1, HP2, HP3 (the "P's"), NE1, NEE2, NE3, LE1, LE2, LE3, ME1, ME2, ME3, HE1, HE2, HE3 (the "E's")

so the column/one cell will always have a combo of the 3 types...I wish to sort them into 3 seperate columns based on their type, (or the second letter in each; S, P, E)

additionally I need a column to the left of the 3 new columns displaying the highest of the ratingsa occuring (N, L, M, or H ...these referring to "None" "Low" "Medium" and "high")

this has been a nightmare - if anyone can help I would be eternally grateful!

here is an example of what I have and what I'm trying to accomplish...eventually I would like to retrieve the data from a seperate worksheet if possible :-)

Thank you!! Massive headache has been avoided! It works perfectly!! Is there a reference I can put somewhere in there to call the column F from another worksheet? I will play with it and see :-)