Combines the text from multiple ranges and/or strings
=CONCAT(text1, [text2], ...)
=CONCAT(A1, " ", B1)