How can I get text value in the cell when I collected value from a few cells?


I have text in Cell1, Cell2, Cell3, Cell4. I need to collect values from these cells.

Cell5 has '=Cell1+Cell2+Cell3+Cell4', or =JOIN(Cell1@row:Cell4@row, " ") for better viewing.

And now I need to get a text value from Cell5. How can I do it?

When I make a copy Cell5 to the word document I just get a formula not a text.