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. Practice alongside me with this spreadsheet.

If you choose to download these materials, you'll be added to my mailing list. You can unsubscribe at any time, but I hope you'll stick around. I share data tricks every week or so.