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?
