Merge text from various cells in Excel

In the cell you want the final merged text, type:

=A1&» «&B1&» «&C1 … &» «&X1

then press enter and you will get your text. You can copy or drag the formula to full columns or selected cells.