Excel, Data, Data Analysis, Analytics.
first and last names in a “full name” column. This is especially useful if you’re analyzing messy survey data. To combine the first and last name columns below, I type: =CONCAT(A2, “ “, B2) “CONCAT” combines text from different cells. “A2” is the first text that shows (first name.) I added