CONCAT
Joins text values together into one.
Syntax
CONCAT(text1, [text2], ...)
Text Functions. Available from Excel 2019.
A worked example
=CONCAT(B2," ",C2)
Returns Marcus Bell
Joins the two values with a space between them.
Where it goes wrong
It does not insert separators for you, and it keeps empty values as gaps.
Consider instead: TEXTJOIN, when you need a separator or want blanks skipped.