Concatenate function in excel

The CONCATENATE function combines text from multiple cells. Here's some random data to illustrate it:

We can use this formula in the "Concatenated Info" column to join the first name, and last name:

Excel Formula

This will concatenate the first name, and last name into one string (e.g., "John Smith").