![merge cells in excel merge cells in excel](https://support.content.office.net/en-us/media/8dd2b96a-7e2e-4587-9f9e-7e74c2944508.jpg)
Now, you have a new worksheet in your workbook with all the text in a single cell. In the end, click OK and click on “Close and Load”.After that, from Merge window, select space as a separator and name the column.For this, select all the columns (select first column, press and hold shift key, click on the last column) and press right click and then select “Merge”.From “Transform” tab, go to Table and click on “Transpose”.
![merge cells in excel merge cells in excel](https://youtubepisnicky.net/storage/2021/06/merge-cells-vertically.png)
Now from here, select the column and go to “Transform Tab”.If will edit your data into Power Query editor.Select the range of cells and click on “From table” in data tab.You can also use it to combine text from a list in a single cell. Make sure to check out this ( Excel Power Query Tutorial). Power Query is a fantastic tool and I love it. In the end, hit enter and you’ll get all the text in a single cell. Here you have used space as a delimiter, TRUE to ignore blank cells and the entire range in a single argument. After that, remove the curly brackets from the start and the end of the array.Now, just select the entire inside portion of concatenate function and press F9.In the B8, insert formula ( =CONCATENATE(TRANSPOSE(A1:A5)&" ")) and do not press enter.Below are the steps you need to follow to combine values from this range of cells into one cell. Look at the below range of cells where you have a text but every word is in a different cell and you want to get it all in one cell.
![merge cells in excel merge cells in excel](https://cdn.extendoffice.com/images/stories/doc-excel/merge-cells-in-table/doc-merge-cells-in-table-6.png)
The best way to combine text from different cells into one cell is using the transpose function with concatenating function. So today in this post, I’d like to share with you 5 different ways to combine text from a range into a single cell. In this situation, you do need a method where you can refer to an entire range of cells to combine them in a single cell. You need to select all the cells of a range one by one, and if you try to refer to an entire range, it will return the text from the first cell. To combine values CONCATENATE is the best way, but with this function, it’s not possible to refer to an entire range.