The CONCAT function automatically ignores empty cells.
The CONCAT function accepts multipleargumentscalled text1, text2, text3, etc.
up to 255 total.
Arguments may be supplied as cell references, ranges, and hard-coded text strings.
Only the first argument is required, and values are concatenated in the order they appear.
To join many values with a common delimiter, see theTEXTJOIN function.
TEXTJOIN can do everything CONCAT can do, but can also apply a delimiter and optionally ignore empty values.
