# How to use concatenate on Google Sheets

**URL:** https://community.glideapps.com/t/how-to-use-concatenate-on-google-sheets/17551
**Category:** Ask for Help
**Created:** [October 24, 2020, 4:50pm UTC](https://community.glideapps.com/t/how-to-use-concatenate-on-google-sheets/17551 "2020-10-24T16:50:37Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)
#### Post date: [October 24, 2020, 4:50pm UTC](https://community.glideapps.com/t/how-to-use-concatenate-on-google-sheets/17551/1 "2020-10-24T16:50:38Z")

</div>

I know how to use a template to concatenate in the Data Editor but I need to do this in the Google Sheet so that it can be read by a on change trigger. I set up the formula in the Google Sheet but I don’t know how to make it apply to all future entries that are written to the sheet.

I have this formula in the second cell of the column:  
=CONCATENATE(“A “, F2,”(”, E2," AMMO)", K2, " BY THE ", O2, “(”, N2, “)”)

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 24, 2020, 6:05pm UTC](https://community.glideapps.com/t/how-to-use-concatenate-on-google-sheets/17551/2 "2020-10-24T18:05:33Z")

</div>

The easiest is something like `=ARRAYFORMULA(A2:A & B2:B & C2:C)`

---

<div class="post-metadata">

### Author: ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)
#### Post date: [October 24, 2020, 6:21pm UTC](https://community.glideapps.com/t/how-to-use-concatenate-on-google-sheets/17551/3 "2020-10-24T18:21:12Z")

</div>

> [@Jeff\_Hager](#):
>
> =ARRAYFORMULA(A2:A & B2:B & C2:C)

Nice, thank you!!!

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [October 25, 2020, 11:35pm UTC](https://community.glideapps.com/t/how-to-use-concatenate-on-google-sheets/17551/4 "2020-10-25T23:35:42Z")

</div>

You should make sure you delete all blank rows from your sheet so new records do not end up on line 1001 and so on,.

---

<div class="post-metadata">

### Author: ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)
#### Post date: [October 26, 2020, 3:14pm UTC](https://community.glideapps.com/t/how-to-use-concatenate-on-google-sheets/17551/5 "2020-10-26T15:14:06Z")

</div>

10-4 thanks