Compute efficient formula, to extract text out of cell

1

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

2

HI Isebar

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

3

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.

4

Hey Isebar, perhaps you could try RegexExtract then?

5

A bit more information would help…

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

Credit: @Rickard_Abraham

1 Like