The current data set has columns for both last name and first name. While this is optimal for sorting and analyzing data, it may occassionally be preferable to have the first and last names combined into a single column. The CONCATENATE function makes this task easy. Utilizing the named ranges created earlier will make it even easier.
The syntax for the CONCATENATE function is as follows:
Because there is a space between the first and last names, it will be necessary to include that space in the function. This can be done by adding a space surrounded by double quotes. Therefore the syntax for this exercise will be as follows: