DelimitedStringFromRangeValues

Returns a delimited string containing the values of a worksheet range.

Usage

@StringFromRange(Range, [ColumnDelimiter], [RowDelimiter], [Transpose])

Argument Name Description
ColumnDelimiter Optional (default is ";"); The character to use to delimit columns.
Range The address of the range to build the string from.
RowDelimiter Optional (default is "|"); The character to use to delimit rows.
Transpose Optional (default is false); If true row and column positions will be swapped.