remove from text if over certaint amount of letters code example

Example: excel trim last character from string

=LEFT(A1, LEN(A1)-1)