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

Andre77

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.

Andrée Starå

Hi @Andre77

I hope you're well and safe!

You'd have to use the Paste Special feature.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!