what is the formula how to delete some letters or numbers behind

[alex_gibson0111]

please help me, what is the formula how to delete some letters or numbers behind

the example id AQUA20224567

I want to change it to AQUA2022

[WillowMobileSys]

AppSheet has LEFT() function will allow you to return a certain number of characters from the left-hand side of a source string

And a RIGHT() functions that returns a certain number of characters from the right-hand side of a source string.

[Steve]

And for completeness: MID() - AppSheet Help