How do I create a multi-cell array formula in Excel whose input is just one cell? -

I have a cell that is called inter-delimited string "NULL 9"

This data is stored Say in A1

I have a function function

  function split cell (string, string) as string () splitCell = split (str, "") termination function  

I am trying to break the cell in a string array, so what I want to do is such a formula such as

{= splitCell (A1) } At A2 and A3 places

, so that "NULL" in A2 and "9" in A3. Where am I going wrong? Please help. Thank you

You need to allocate the result of the partition as a type, and if you get the result To get the vertical rather horizontal you need to move it.

  Variient split cell = app as a public function split cell (Range Edge Range) Transjees (Split (RNG)) and Function