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:

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 -