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