RANGETOCSV

Returns a CSV (comma separated version) representation of a range.

Syntax

RANGETOCSV(range; columnDelimiter; rowDelimiter; option)

• range - the range which should be converted to a csv text - Value type: range with cells of value type “text”

• columnDelimiter - the character which separates cell values column-wise - Value type: text (optional, default value: “;”)

• rowDelimiter - the character which separates cell values row-wise - Value type: text (optional, default value: empty)

• option - option to escape delimiters in the cell values - Value type: constant (optional, default value: noescaping) Possible values are:

  1. noescaping - delimiter characters in cell values are not converted

  2. escaping - delimiter characters in cell values are converted (see remarks)

Remarks

1. rowDelimiter can be empty, then only the single rows of range are concatenated into a column range.

2. To apply special characters like tab, carriage return or line feed, use the function CHAR for the delimiters (see example below).

3. If option is escaping, the delimiter characters are escaped (converted) in the following way:

   1. all double quotes of all texts in range are automatically replaced with two double quotes.

   2. if a cell value contains one of the two delimiters or a double quote.

   3. the cell value is automatically enclosed with double quotes.

Examples