concatenate from a specific position

AppSheet AppSheet Q&A
, , ,
1

Hi, is it possible to concatenate text from a specific letter

for example if the column contains this

“Hello How”

Now I want to concatenate from string number 7 from the left side.

so new value should be “How”

2

I am able to solve it via MID()

https://support.google.com/appsheet/answer/10107345