Google Spreadsheet Tricks

Google spreadsheet tricks #

Remove characters from a string in a cell with Google spreadsheet #

Goal #

Remove the first 2 characters from a string in cell D1 :

 =RIGHT(D1,LEN(D1)-2)

Explanations #

  • 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 :

 =LEFT(D1,LEN(D1)-2)