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)

Hey Seraphin -

You can use the following formulas to get the data left of the colon, and the data right of the last colon. In this case, the sheet containing your unparsed cells is Sheet1, starting in cell A1.
Sheet2!A1 = =LEFT(Sheet1!A1,FIND(":",Sheet1!A1,1)-1)
Sheet3!A1 = =RIGHT(Sheet1!A1,LEN(Sheet1!A1)-FIND("*",SUBSTITUTE(Sheet1!A1,":","*",LEN(Sheet1!A1)-LEN(SUBSTITUTE(Sheet1!A1,":","")))))

Another brilliant way I saw to do this would be to use
Sheet3!A1 = =TRIM(RIGHT(SUBSTITUTE(Sheet1!A1,":",REPT(" ",99)),99))

which essentially replaces each instance of ":" with 99 blank spaces. Then the function trims the 99 right-most characters. , which guarantees that you don't pick up any values from before the last ":".

Just drag to the same 100 x 50000 cells on both sheets 2 and 3 and you should be gold!