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
=CONCATENATE(A2, " ", B2)
This will concatenate the first name, and last name into one string (e.g., "John Smith").
