Techniques For Concatenating Data In Microsoft Excel
Concatenation is the process of stringing together different pieces of information to form a new piece of data. For example, if we have columns containing people’s title and first name and another containing their last name, we could use concatenation to create their full name. All we need to do is to string together the title, first name and last name.