how to parse and select certain data in a cell

Have the following type of data in 100x50000 cells and need to parse and select only part of the data to make a new spreadsheet

0/0:31,0:31:64:0,64,959

For example, need to make one new spreadsheet containing all the info before the first `:` (0/0)
and another one containing all the info after the last `:` (0,64,959)
I know I can do `text-to-column` and set the `delimiter`, but the output would generate a BIGGER spreadsheet that will be more difficult for me to select for the info I need.
Is there another way to do it? (have been trying with LFET, LEN, RIGHT MID, but none seems to work the way I had hoped)