Text To Table

TextToTable.SK is a SheetKraft function used to convert text value to table array.

Working:

  • Type TextToTable.SK() formula in the cell, then click on the function symbol fx near the formula bar, TextToTable.SK function Arguments UI will appear as shown in the figure below:

  • TextToTable.SK function has 3 arguments:

Note: Only CST(Comma Separated Table) is supported currently.

Let us consider an example:

  • We have text value as shown below:

The text value is displayed in text editor as shown below-

The text value is displayed in excel as shown below-

  • We need to get the text value converted to table array; we will use TextToTable.SK,

o The format is CST.

o Value is cell which contains the text value, i.e. cell G3.

o Column Names are H6:J6 i.e. (name, age, subject) OR write {“name”,”age”,”subject”}

  • The result is -