# Text editing

**URL:** <https://community.glideapps.com/t/text-editing/27697>\
**Category:** Ask for Help\
**Created:** [June 6, 2021, 1:54am UTC](https://community.glideapps.com/t/text-editing/27697 "2021-06-06T01:54:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\
**Post date:** [June 6, 2021, 1:54am UTC](https://community.glideapps.com/t/text-editing/27697/1 "2021-06-06T01:54:45Z")

</div>

I would like to use the email string and cut of the domain portion - convert [jelena.dolic@xxxxx.com](mailto:jelena.dolic@xxxxx.com) into  
jelena.dolic

Please help

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 6, 2021, 2:15am UTC](https://community.glideapps.com/t/text-editing/27697/2 "2021-06-06T02:15:23Z")

</div>

Unfortunately Glide computed columns do not support sting manipulation functions, so there is no easy way to do that within Glide. The simplest way to achieve that at the moment would be with a GSheet function.

---

<div class="post-metadata">

**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\
**Post date:** [June 6, 2021, 2:19am UTC](https://community.glideapps.com/t/text-editing/27697/3 "2021-06-06T02:19:26Z")

</div>

Thanks, sound great, but there I would have to figure out how to force a calculation on a newly created line. Would you be able to suggest?  
Thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 6, 2021, 2:20am UTC](https://community.glideapps.com/t/text-editing/27697/4 "2021-06-06T02:20:41Z")

</div>

yes, you can use an [ARRAYFORMULA](https://support.google.com/docs/answer/3093275?hl=en)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [June 6, 2021, 2:42am UTC](https://community.glideapps.com/t/text-editing/27697/5 "2021-06-06T02:42:06Z")

</div>

`=arrayformula(if(A2:A="",,left(A2:A,find("@",A2:A)-1)))`

change A2:A if email is not in first column

---

<div class="post-metadata">

**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\
**Post date:** [June 8, 2021, 2:54pm UTC](https://community.glideapps.com/t/text-editing/27697/6 "2021-06-08T14:54:36Z")

</div>

Thanks 😀

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/text-editing/27697/7 "2024-01-17T16:51:53Z")

</div>