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