CellFormulaA1StyleRangeConcatenate
[this page | pdf]
Function Description
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
Output type / Parameter details
Output type: String
Parameter Name | Variable Type | Description |
StartCellRow | Integer | Row of top left hand corner of range |
StartCellCol | Integer | Column of top left hand corner of range |
NoRows | Integer | Number of rows in range |
NoCols | Integer | Number of columns in range |
DelimiterString | String | Delimiter string to insert between consecutive cell values |
TransposeRange | Boolean | If true then work down each column in turn, else work across each row in turn |
FrozenRows | Boolean | If true formula uses absolute row cell references, else relative ones |
FrozenCols | Boolean | If true formula uses absolute column cell references, else relative ones |
Links to:
-
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