Return the concatenation of values in a particular range

Return two strings joined together

Built-in Functions

CONCAT - The text string that is a concatenation of cell ranges and strings.
TEXTJOIN - The text string that is a concatenation of several strings with a delimiter.