Remove last 3
=LEFT(A2,LEN(A2)-3)Keeps everything except the final three characters.
PASTE-READY RECIPE
Remove the First or Last Characters in Google Sheets
Trim a fixed number of characters from the beginning or end of text.
QUICK ANSWER
The formula and where it fits.
Trim a fixed number of characters from the beginning or end of text. Use =RIGHT(A2,LEN(A2)-3), then replace the sample ranges with the columns in your sheet.
RIGHT returns the remaining characters after subtracting the first three.
- Put the source data under one header row.
- Paste the formula into an empty result cell.
- Change the ranges and criteria to match your sheet.
- Check the result against one row you can verify manually.
TRY ITEdit the table.
Edit the table.
Watch the result change.
| A | |
|---|---|
| 1 | Imported code |
| 2 | |
| 3 | |
| 4 |
FORMULA OUTPUT10482 · 20911 · 87320Recalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Remove first character
=RIGHT(A2,LEN(A2)-1)Drops one leading character.
Remove a known prefix
=REGEXREPLACE(A2,"^ID-","")Only removes ID- when it appears at the start.
COMMON ERRORS
When the result looks wrong.
The requested count exceeds the text length
Check LEN first or wrap the formula in IFERROR.
The prefix length varies
Use REGEXREPLACE for a known prefix rather than a fixed character count.
QUESTIONS
Answers before you paste.
The requested count exceeds the text length
Check LEN first or wrap the formula in IFERROR.
The prefix length varies
Use REGEXREPLACE for a known prefix rather than a fixed character count.
MAKE IT YOURS
Adjust this formula →Change the ranges, labels or criteria.
Send this recipe to the SheetSteps assistant and describe how your columns are arranged.