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
Suggestion from Marcílio Lobão - BRAZIL
Barbie, Good afternoon.
As you have a typical CSV file, I suggest you use the function "Text to Column" and split the data into columns.
Then it will be immensely easy to make the sortings and everything else you need.
I noticed in your sample data you have two kinds of headers.
One header on the first line and another in the middle of the data.
So pay attention to this when making the separation data.
Is that what you wanted?
I hope I have helped.
Best regards,
--------------------------------------------------
Belo Horizonte, Brasil
Marcílio Lobão