February 19, 2020 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) Read more