how to delete the last character of a string in excel code example Example: excel trim last character from string =LEFT(A1, LEN(A1)-1)