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?

  • The INDIRECT function is capable of doing that, but in this instance, the formula throws an error as the INDIRECT formula needs a cell/range reference. Jun 15, 2019 at 15:38

1 Answer 1

  • instead ={E2} use SPLIT formula like:

    =SPLIT(E2; ",")

    enter image description here

  • also, you can do it directly by pressing LEFT ALT + D + E

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.