Discard CONCAT and use TEXTJOIN

Don't miss how the new TEXTJOIN formula available in MS Excel 365 is an improvement over the old CONCAT formula.

TEXTJOIN gives you the option to add delimiters in between a combined range of cells, and choose what to do when there are empty spaces in the range.

The beginning of the formula begins with the delimiter that you select:

. . . this is followed by TRUE or FALSE - TRUE stops empty spaces from being included - FALSE will add them in. Conclude the formula with the range you want to combine.

It is possible to combine multiple ranges with TEXTJOIN

=TEXTJOIN("; ",TRUE,A2:F2,A3:F3)