Remove characters from a string in a cell with Google spreadsheet

Categories: Google|Tags: |

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