CellFormulaA1StyleRangeConcatenate

[this page | pdf]

Returns text to create a formula that will concatenate the values in a range of spreadsheet cells, including a delimiter (i.e. a specific piece of text) between each entry.

StartCellRow and StartCellCol (both integers) define the top left hand corner of the range, the size of which is defined by NoRows and NoCols (also both integers). If TransposeRange is true then the resulting formula will cycle through the cells starting at the top left hand corner working downwards and then across, whereas if TransposeRange is false then the resulting formula works across then down. The string inserted between each cell value is DelimiterString. If FrozenRows is true then the formua created by this function includes absolute row cell references, e.g. A$1, whereas if FrozenRows is false then it creates relative row cell references, e.g. A1. FrozenCols does the same but for column cell references, e.g. $A1 versus A1.

This function is particularly useful for creating formulae that can be used within a WEBSERVICE call or equivalent, see e.g. Introduction to the Nematrian Spreadsheet Library.

NAVIGATION LINKS
Contents | Prev | Next

-          Interactively run function

-          Interactive instructions

-          Example calculation

-          Output type / Parameter details

-          Illustrative spreadsheet

-          Other General functions

-          Computation units used

Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement