Table To Text

TableToText.SK is a SheetKraft function used to convert a table array into a single text value.

Working:

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

  • TableToText.SK function has 3 arguments:

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

Let us consider an example:

We have table array as shown below:

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

o The format is Comma Separated text (CST)

o Column Names are cells C4:E4 i.e. (name, age, subject)

o Input Table range is C5:E8. If the table range is dynamic use RegionDown.SK function-RegionDown.SK(C5:E5).

  • When we view the output in the text editor, it is displayed as -