How to join text in different cells

One really handy thing you can do in Excel is join text from different cells. Joining cells is sometimes called 'concatenation'.

In this example we have a column of first names, a column of last names, and some cells that we want to populate wth both first an last names.

So how might we go about that. Well, it's pretty simple.

Click on the video for the details.