Combining first and last names using Concatenate

In this exercise, you need to combine the first and last name given and add a space (” “) in-between. You can use the Concatenate function to accomplish this.

Your answer is checked in cell C8. You can fill in the formula in cell C1 and use the autofill square at the bottom-right of the cell to copy the formula down to C8. Don’t forget the space in-between the names!

Spreadsheet editor
Good job! Note that you can also use the Concatenate function with more arguments. Up to 255!

Leave a Comment