Google

Home/Google

Remove characters from a string in a cell with Google spreadsheet

2015-04-20T07:55:34+00:00Categories: 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 [...]