How to Use the Concatenate Function in Excel

There are two ways to do this:

1. Add double quotation marks with a space between them " ". For example: =CONCATENATE("Hello", " ", "World!").
2. Add a space after the Text argument. For example: =CONCATENATE("Hello ", "World!"). The string "Hello " has an extra space added.