how to erase /disappear four last character of a data

Hello Everyone.. I just wonder how to erase /disappear four last character of a data

when I use left function, LEFT([name],8) from this data aabbccdd3333 it will count from the beginning 8 character aabbccdd

but I need to erase from the four last character

like these:

aabbccdd3333 results aabbccdd

aabbccddee676a resuts aabbccddee

aabbccddefyhhu results aabbccddef

any idea How to make it happen?

LEFT([Name],LEN([Name])-4)

LEN() - AppSheet Help

2 Likes

thanks dude :+1:

2 Likes