ConcatString

Use ConcatString to generate a single string with values separated by asterisks.

ConcatString is a helper function that can be used to input an array of cell values and output a single string that contains the values separated by a user-defined symbol. ConcatString requires a minimum of 1 cell and a maximum of 20.

Syntax

ConcatString("<symbol>",<cell_range_min>:<cell_max_max>)

Argument	Description	Required/Optional
Symbol	The symbol that you want to use to separate the values. Note: Values will be spliced with nothing in between them if this argument is empty.	Optional
`<cell_range_min>:<cell_range_max>`	A range of cells that contains the values to concatenate. For example, `F8:H8` specifies the cells F8, G8, and H8.	Required

Argument

Description

Required/Optional

Symbol

The symbol that you want to use to separate the values.

Note: Values will be spliced with nothing in between them if this argument is empty.

Optional

<cell_range_min>:<cell_range_max>

A range of cells that contains the values to concatenate.

For example, F8:H8 specifies the cells F8, G8, and H8.

Required

Example

The following examples assume that the values of the cells at F8, G8, and H8 are laptop, tablet, and mobile.

Example input:

ConcatString("^",F8:H8)

Example output:

"laptop^tablet^mobile"

Example input:

ConcatString("",F8:H8)

Example output:

"laptoptabletmobile"

Example input:

ConcatString(,F8:H8)

Example output:

"laptoptabletmobile"