Excel, Data, Data Analysis, Analytics.
quotation marks with a space so there is a space between the first and last names. If I didn’t do this, the full name would appear as “MarySmith”. “B2” is the last text that shows (last name.) I use the formula =CONCAT(A2, “ “, B2) to combine the first and last names. Next, I drag the formula down