and as for the other 2 columns;

I also need a column which will return only the letters before the space at the beginning (if any, see the "PCK" & "RTN" in the first list)
=IF(ISNUMBER(FIND(" ",A1)),LEFT(A1,FIND(" ",A1)-1),"")


a column which will only return anything after the four digits after the dash (if any, results from the first list would be A, B, A, A1).
=IFERROR(MID(REPLACE(A1,1,FIND("-",A1)-3,""),8,255),"")