How do i combine multiple cells into one cell with multiple lines

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access!

- Lifetime Access!

View Course

Add to Favorites Favorited

There are two easy ways to combine values from multiple cells in Excel.

In order to do this, we need to do what is called "concatenate" values.

Method 1 - CONCATENATE Function

1. Type =CONCATENATE( into the cell where you want the combined text to appear:
   
2. Select the first cell that you want to combine:
   
3. Type a comma and then select the next cell that you want to combine:
   
4. Repeat step 3 until you have selected all of the cells:
   
5. Type the closing parenthesis for the function and hit Enter and that's it!
   

Now all of the text is combined but it looks rather odd because there are no spaces between the text.

Add Spaces Between Combined Text

We follow the same steps as above except that, between each cell that we want to combine, we type this " " which is

how to merge two cells in one column

how to combine two columns in one sql