We have MID()
- However, the third part that you enter here is the “number of characters”
This can be really hard to derive sometimes.
With Google Apps Script, there’s a function called SubString() - which is almost exactly the same thing as MID
- The difference is the third part that you enter is the position to stop at.
Can we get something where we specify the index position where to stop?
I actually assumed this was how MID() worked (I’ve never used it), I was surprised to find that I had to specify the number of characters.
As always, thanks for considering