sorting by partial name – I think?

How do I sort within a cell? For instance………… I have one-column table (all values in each row below are in *one* single cell).
MLDG,TOP,SIDE,PNE,384 OLD 839
EAR,POP,BLNK,106,27
EAR,POP,BLNK,106,27
EAR,POP,BLNK,106,27
EAR,POP,BLNK,106,27
EAR,POP,BLNK,106,27
CAP,FLAT,POP,BLNK,121
MLDG,TOP,SIDE,POP,120
EAR,OAK,BLNK,256,20.5
EAR,OAK,BLNK,256,20.5
EAR,OAK,BLNK,256,20.5
CAP,FLAT,PNE,BLNK,351 6/6-22
CAP,FLAT,PNE,BLNK,351 6/6-22

I want to sort by species of *wood* which in this case is Oak, Pine, Poplar (OAK,PNE,POP)….etc. If you look at the top line, it starts with MLDG,TOP,SIDE,PNE,384……… How do I pick out the PNE for pine and move it to the front of the cell so I can sort by wood species (in this case PNE)? Same with the other cells below, POP or OAK….

I’m trying to sort on species so I know which is causing us the most headaches regarding defects we are seeing in my shop. Any help would be appreciated!
Barbie

Leave a Reply

Your email address will not be published. Required fields are marked *