CONCATENATE names
BeginnerIn many datasets, first and last names are stored in separate columns. To create a clean full name field (for badges, emails, or exports), you need to join text together.
In Excel, you can combine text in a few common ways:
CONCATENATE(text1, text2, ...)CONCAT(text1, text2, ...)- the
&operator
What you need to do
- Click cell C2.
- Create a formula that combines the first name in A2, a single space, and the last name in B2.
- Press Enter.
- Copy your formula down from C2 through C9 so every row has a full name.
When you're done, cells C2:C9 should all show full names.
Need some help?
Hint 1
Try the `&` operator: join three pieces (first name, a space, last name).
Hint 2
The space between names is text, so it needs double quotes in your formula: " ".
Hint 3
Use A2 + space + B2 in C2, then fill the formula down to C9. Each row should reference its own A and B cells.
Related function(s)
CONCATENATE names
BeginnerIn many datasets, first and last names are stored in separate columns. To create a clean full name field (for badges, emails, or exports), you need to join text together.
In Excel, you can combine text in a few common ways:
CONCATENATE(text1, text2, ...)CONCAT(text1, text2, ...)- the
&operator
What you need to do
- Click cell C2.
- Create a formula that combines the first name in A2, a single space, and the last name in B2.
- Press Enter.
- Copy your formula down from C2 through C9 so every row has a full name.
When you're done, cells C2:C9 should all show full names.
Need some help?
Hint 1
Try the `&` operator: join three pieces (first name, a space, last name).
Hint 2
The space between names is text, so it needs double quotes in your formula: " ".
Hint 3
Use A2 + space + B2 in C2, then fill the formula down to C9. Each row should reference its own A and B cells.