The CONCATENATE function is used to join the contents of multiple cells. For example, if you have a worksheet with first names in one column and last names in another column, you can use the CONCATENATE function to join the first and last names into one column. To use this handy function, follow these three steps.