Syntax:

=CONCATENATE(Argument1, Argument2)

• You may have recognized that the first and last names do not have a space between them. That’s because CONCATENATE will only combine what you tell it to mix. If you want punctuation, spaces, or other features to appear in the cell, you must instruct CONCATENATE to include them.
• We may easily add another parameter to add a space: ” ” (two double quotations surrounded by a space) Make sure to separate the three arguments with commas: =CONCATENATE(A2, “,” B2)
• As in the preceding example, you may insert a comma, a word, or any other character between the names.