If I have a formula:
I get a 5 column set of numbers with 1 in the first, 2 in the next and so on.
However, if I have a cell that contains the string
1,2,3,4,5 in cell E2
and I try
I get the same result as if I did
=E2 - a single cell with comma separated values.
Is there a function in Google Sheets that says, "treat the argument as if it were typed at this point?