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.

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.