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 C8 to combine the first name in A8, a space, and the last name in B8 into a full name.
The other rows are available for you to practice in.
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(A8, " ", B8)
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 C8 to combine the first name in A8, a space, and the last name in B8 into a full name.
The other rows are available for you to practice in.
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(A8, " ", B8)