# Compute efficient formula, to extract text out of cell

**URL:** <https://connect.superhuman.com/t/compute-efficient-formula-to-extract-text-out-of-cell/50987>\
**Category:** Ask the Community\
**Created:** [September 5, 2024, 3:41pm UTC](https://connect.superhuman.com/t/compute-efficient-formula-to-extract-text-out-of-cell/50987 "2024-09-05T15:41:42Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Isebar\_de1](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@Isebar\_de1](https://connect.superhuman.com/u/Isebar_de1)\
**Post date:** [September 5, 2024, 3:41pm UTC](https://connect.superhuman.com/t/compute-efficient-formula-to-extract-text-out-of-cell/50987/1 "2024-09-05T15:41:43Z")

</div>

Hi community,

What the most compute efficient way, to extract a text part out of a cell?

Ideally, i could set a start point (that should not be included),

and an endpoint that should not be included as well.

Thx,  
Marc

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [September 5, 2024, 4:11pm UTC](https://connect.superhuman.com/t/compute-efficient-formula-to-extract-text-out-of-cell/50987/2 "2024-09-05T16:11:19Z")

</div>

HI Isebar

It sounds like Middle() will do the trick. Some examples are on the page below:

https://coda.io/embed/bwDkOkBNDa/_suUGDbiv?viewMode=embedplay

---

<div class="post-metadata">

**Author:** ![Isebar\_de1](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@Isebar\_de1](https://connect.superhuman.com/u/Isebar_de1)\
**Post date:** [September 6, 2024, 5:53am UTC](https://connect.superhuman.com/t/compute-efficient-formula-to-extract-text-out-of-cell/50987/3 "2024-09-06T05:53:26Z")

</div>

Start an end points are also just somewhere inside the cell. So there’s no fixed after some characters, kind of thing. I’m pretty sure I need to combine it with something else, but I don’t know how.

---

<div class="post-metadata">

**Author:** ![Rickard\_Abraham](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/rickard_abraham/32/35007_2.png) [@Rickard\_Abraham](https://connect.superhuman.com/u/Rickard_Abraham)\
**Post date:** [September 6, 2024, 7:34am UTC](https://connect.superhuman.com/t/compute-efficient-formula-to-extract-text-out-of-cell/50987/4 "2024-09-06T07:34:30Z")

</div>

Hey Isebar, perhaps you could try `RegexExtract` then?

https://coda.io/embed/MVRa7tcuGD?viewMode=embedplay#_tuCRS/r89&view=full

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [September 6, 2024, 11:51am UTC](https://connect.superhuman.com/t/compute-efficient-formula-to-extract-text-out-of-cell/50987/5 "2024-09-06T11:51:28Z")

</div>

A bit more information would help…

---

<div class="post-metadata">

**Author:** ![joost\_mineur](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joost_mineur/32/30539_2.png) [@joost\_mineur](https://connect.superhuman.com/u/joost_mineur)\
**Post date:** [September 6, 2024, 1:04pm UTC](https://connect.superhuman.com/t/compute-efficient-formula-to-extract-text-out-of-cell/50987/6 "2024-09-06T13:04:16Z")

</div>

```auto
RegexExtract(thisRow.Name, "START (.*) END", "s").last()

```

Credit: @Rickard_Abraham

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [December 5, 2024, 1:04pm UTC](https://connect.superhuman.com/t/compute-efficient-formula-to-extract-text-out-of-cell/50987/7 "2024-12-05T13:04:29Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.