TEXTJOIN

Joins a range of texts with a separator, optionally skipping empty cells.

Group: Text

Syntax

TEXTJOIN(separator, ignore_empty, range)

Example

← All of Excel Function Reference