Excel Data
Get the last character in excel cell l using formula - like  to remove special character
=RIGHT(A1,LEN(A1)-(LEN(A1)-1))

Extract all but last one characters from string Select a blank cell and type this formula =LEFT(A1,LEN(A1)-1)