Google spreadsheet tricks #
Remove characters from a string in a cell with Google spreadsheet #
Remove the first 2 characters from a string in cell D1 :
LEN(D1)returns the length of the string in a cell.
RIGHT(D1, X)returns a substring from the end. First argument is the string. Seconde argument is the length of the substring to return.
Alternatively, to remove the last 2 characters, use :