Comments on: How to Combine Cells in Google Sheets [Easy Guide]

By: jmarkus

jmarkus — Fri, 02 Feb 2024 13:05:44 +0000

In reply to Kathy.

=TEXTJOIN(" ", TRUE, IMPORTRANGE("1rTm9iaZNW68gG0M2mC2z0jimLVjbCI_uTJTkq6uq2DE", "Directory!C5:E5"))

Ensure that you replace the URL in the IMPORTRANGE function with the correct spreadsheet key. Also, make sure that you've granted access to the external sheet. If you want to reorder the names within the combined cell, you can manually arrange them as needed. If you specifically want D5, E5, C5, you can adjust the IMPORTRANGE range accordingly. Note that IMPORTRANGE pulls data, but the order is not changed directly within the formula.

By: Valerie Tantlinger

Valerie Tantlinger — Mon, 20 Feb 2023 19:37:15 +0000

Hi. I am looking at how to keep a running total of a column that gets rows added to it multiple times a day. Is there a way to still keep the total going and adding my rows on a daily basis? I am inserting rows as needed and want to keep the total of my column up to date as I add the rows. Thanks!

By: Kathy

Kathy — Mon, 24 Jan 2022 01:54:41 +0000

This is the best help I found but for ONE thing…
I want to take cells C5, D5 and E5 from worksheet “Directory”,
and combine them into ONE cell on worksheet “Ann Mtg”. The cells are “name” fields (1 last and 2 first).
Ideally, I’d also like to re-order them in the new cell as D5, E5, C5, but I’d be OK with simply C5:E5.

I tried to imbed importrange within textjoin, in several ways, but I just keep getting the error “formula parse error”. I cannot figure out how to make this work. Here’s what I have at the moment:

=textjoin(“ “,TRUE,IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1rTm9iaZNW68gG0M2mC2z0jimLVjbCI_uTJTkq6uq2DE/edit#gid=667859876″,”Directory!C5:E5”))

Can you help me???