You don’t have to create complicated formulas to combine text from multiple columns to a single column. In this Excel tip, we will show you how to quickly and easily combine your data from multiple columns into one column.
In the example below. We have five different columns of data and we need this data to be combined into one column. We use the "&" sign to achieve this.
Download the workbook to practice.
For this example, the formula is: =A5&B5&C5&D5&E5
If you would like spaces between text, you will need to use the Concatenate formula.
Your formula will be: =CONCATENATE(A5,” “,B5,” “,C5,” “,D5,” “,E5,”)