Concatenation

Learning Objectives:

  • Learning what concantenation is and its importance in cleaning data in Excel.

Concatenation

Concatenating means to combine things together. This function is used to combine multiple cells without adding any delimiters between the combined cell values.
Delimiters are spacing or symbols used to separate content elements from each other. It is typed =CONCAT

Excel Concatenation example