TEXTJOIN

Syntax

=TEXTJOIN(delimiter;ignore_empty;text1;[text2];...)

Description

Combines the text from multiple ranges and/or strings with a delimiter.

Related Functions