Previous Lecture Complete and continue  

  Combine Content from Several Cells into a Single Cell with Concatenate and &*

Sometimes you need to combine content from several cells into a single cell. This is called concatenation, which means chaining together.

For example, let's pretend you have first names in one column and last names in another. You could combine the first and last names together in a third column with concatenation.

In this video, we'll talk about what concatenate is and how you can use either =concatenate or the ampersand to join contents from a few different cells together.