Combining Content from Multiple Cells into a Single Cell
Use the & operator to concatenate letters and numbers from a few different cells into a single cell. In this example, I combine first names from one column and last names from another column into a single column that displays the First Last format.