Combine text with CONCATENATE
BeginnerSo far you've worked with functions that use numbers. Text functions take text as input, return text as output, or both.
One important detail: text values in Excel formulas must be wrapped in double quotes ". This tells Excel to treat them as text rather than cell references or function names.
The CONCATENATE function joins multiple values together into one string:
=CONCATENATE("text1", "text2", "text3")
This returns text1text2text3. It simply combines everything you give it, in order.
Your task
The spreadsheet has first names in cells A1:A8 and last names in cells B1:B8.
Use the CONCATENATE function in cell C1 to combine the first name in A1, a space, and the last name in B1 into a full name.
Then copy the formula down through C8 so every row has a full name.
Need some help?
Hint 1
You need three arguments in your CONCATENATE function: the first name cell, a space in quotes, and the last name cell.
Hint 2
Your formula should follow this pattern: =CONCATENATE(A1, " ", B1), then copy it down by dragging the small square in the bottom right of the cell down.
Related function(s)
Combine text with CONCATENATE
BeginnerSo far you've worked with functions that use numbers. Text functions take text as input, return text as output, or both.
One important detail: text values in Excel formulas must be wrapped in double quotes ". This tells Excel to treat them as text rather than cell references or function names.
The CONCATENATE function joins multiple values together into one string:
=CONCATENATE("text1", "text2", "text3")
This returns text1text2text3. It simply combines everything you give it, in order.
Your task
The spreadsheet has first names in cells A1:A8 and last names in cells B1:B8.
Use the CONCATENATE function in cell C1 to combine the first name in A1, a space, and the last name in B1 into a full name.
Then copy the formula down through C8 so every row has a full name.
Need some help?
Hint 1
You need three arguments in your CONCATENATE function: the first name cell, a space in quotes, and the last name cell.
Hint 2
Your formula should follow this pattern: =CONCATENATE(A1, " ", B1), then copy it down by dragging the small square in the bottom right of the cell down.