google sheets remove left characters code example

Example: google sheets remove first character

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,"")