Goal :

Remove the first 2 characters from a string in cell D1 : =RIGHT(D1,LEN(D1)-2)

Explanations:

  • =RIGHT(D1,LEN(D1)-[number of characters to remove])
  • RIGHT(D1) returns the last X characters of a certain string, based on a number of characters you specify. Like: RIGHT(text,num_chars)
  • LEN(D1) returns the length of the string in a cell