How to Concatenate (or Combine) Data in Microsoft Excel (CONCAT Function)

Microsoft Excel allows us to combine (or concatenate) data from multiple cells into one using the CONCAT function. As an example, if you have first and last names in separate columns, you can combine them into one full name column. CONCAT is the function we use to do this. (As a note, CONCAT has replaced the CONCATENATE function in Microsoft Excel.)