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
One reply on “Remove characters from a string in a cell with Google spreadsheet”
Works great. Thank you!