Skill level - Newbie

I have a cell in a table containing user entered Comma separated values.
How can I process it so that user entered values can be referred to just like in an array? Is it possible to do something like cell.value[0]?

For example --
cell A1 has values red, blue, green. B1 has a formula that can refer to "red" in A1 by writing something like A1.value[0]

Is it possible to have a function return values to another cell reference than from the cell where it is called?

Like a UDF called functionIndividualValues(InputcellReference, OutputCellReference)
functionIndividualValues(A1, A2) meaning that the input string for the function is in A1 and the output should go to the cell A2