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.
My life, universe and everything
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.