Resolved >>> Comma separated values in a cell

[usr789]

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

[lecxe]

Hi

How can I process it so that user entered values can be referred to just like in an array?

A solution is to use a UDF, like

Please Login or Register  to view this content.

With you example, with A1 with red, blue, green, in B1

=CSV_Item(A1,2)

gives blue.

Another solution would be a formula. It could get the element index from a cell.

Remark: I did not include error processing

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

Used as a UDF, no. Like a worksheet formula a UDF is passive, it simply calculates the value of the cell. A UDF cannot take any active action like inserting a row, deleting a cell, writing another cell, etc.

[usr789]

Wonderful.
Thanks much.

[usr789]

@lecxe
--But your function had to be modifed this way to run without error

Please Login or Register  to view this content.

Thanks