CONCATENATE in Excel: combine text strings, cells and columns

READ ORIGINAL POST HERE

In this tutorial, you will learn various ways to concatenate text strings, cells, ranges, columns and rows in Excel using the CONCATENATE function and "&" operator.

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.

In this tutorial, we are going to explore various techniques of Excel string concatenation so that you can choose the method best suited for your worksheets.

• What is "concatenate" in Excel?
• Excel CONCATENATE function
• Concatenation operator (&)
• Concatenate cells with space, comma and other chars
• Concatenate strings with line breaks
• Concatenating two or more columns in Excel
• Concatenating a range of cells
• Concatenate numbers and dates in the desired format
• Opposite of CONCATENATE in Excel (split cells)
• Merge Cells add-in - formula-free way to concatenate cells in Excel