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. In your Excel workbooks, the data is not always structured according to your needs. 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.
