The best way of  combining text from different cells into one cell is using the transpose function with concatenating function.
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  all of them in one cell.
Below are the steps you need to follow to combine values from this range of cells into another cell.
In B8, insert the following formula and do not press the  enter key.
=CONCATENATE(TRANSPOSE(A1:A5)&” “)
Now, you can just select the entire inside portion of the concatenate function and press F9. It will convert it into an array.
After that, remove the curly brackets from the starting to the end of the array.
In the end, hit enter button.