google sheets first character of cell 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,"")
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,"")