In your Excel workbooks, the data is not always structured according to your needs. Often you may want to split the content of one cell into individual cells, or do the opposite – combine data from two or more columns into a single column. Common examples that require concatenation in Excel are joining names and address parts, combining text with a formula-driven value, displaying dates and times in the desired format, to name a few.
What is “concatenate” in Excel?
In essence, there are two ways to combine data in Excel spreadsheets:
- Merge cells
- Concatenate cells’ values
When you merge cells, you “physically” merge two or more cells into a single cell. As a result, you have one larger cell that is displayed across multiple rows and/or columns in your worksheet.
When you concatenate cells in Excel, you combine only the contents of those cells. In other words, concatenation in Excel is the process of joining two or more values together. This method is often used to combine a few pieces of text that reside in different cells (technically, these are called text strings or simply strings) or insert a formula-calculated value in the middle of some text.
You can concatenate any numbers of cells using a CONCATENATE function in excel.
The CONCATENATE function in Excel is designed to join different pieces of text together or combine values from several cells into one cell.
The syntax of Excel CONCATENATE is as follows:
CONCATENATE(text1, [text2], …)
Watch the video below to do Concatenate in Excel practically.