Concat function in excel

The CONCAT 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").