The function Textjoin helps to concatenate a list or range of strings using a delimiter.
This function produce better results than CONCAT.
Syntax:
=Textjoin(delimiter, ignore empty, strings to join)
Delimiter. character or string to insert between each text item.
Ignore empty. if TRUE, ignores empty cells
Strings to join. can be a text string within quotation marks, or a cell reference or range to be joined