I'm going to use the concatenate function to join different text strings including the first and last name. So this is found under the formulas text group, concatenate, execute concat, you'll see that I want to have the first name to go first here, then my space, my add a space in the line to there. Then third argument is going to be their last name. Before I hit OK, I'll just verify the correct setting right here. There we go copy it down. And I've got their names selected there.

Okay, so interesting in the new function and excels concat you might have an older version of Excel, it will say concatenate, they mean the same thing.