Using the RIGHT Formula =RIGHT(A2, LEN(A2)-1) Using the MID Formula =MID(A2,2,LEN(A2)-1) Using the REPLACE Formula =REPLACE(A2,1,1,"")