Remove First 3 Characters in Excel — Instant Formula, No Manual Work | SheetMaster
Removes the specified number of characters from the beginning of a text string.
Remove the First N Characters in Excel or Google Sheets
Common when cleaning CSV prefixes, IDs, or fixed-width junk at the start of a cell. Use RIGHT with LEN so the number of characters to drop is explicit.
Why LEN minus N?
RIGHT(text, LEN(text)-N) keeps everything after the first N characters. Change N to match "remove first 3 characters" or any count.
Real-World Use Cases
- Cleaning product codes: Remove prefix "SKU-" from "SKU-12345" → "12345".
- Phone numbers: Strip country code "+1" from "+15551234567" → "5551234567".
- CSV imports: Remove quote character or "#" prefix from imported data.
- Serial numbers: Drop fixed-length batch prefix from part numbers.
Alternative: Using MID Instead
You can also use =MID(A2, N+1, LEN(A2)). The logic is the same but some users find MID more intuitive since the second parameter is the starting position. For N=3: =MID(A2, 4, LEN(A2)).
Variable N
Put N in a cell (e.g. D1) and reference it: =RIGHT(A2,LEN(A2)-D1) so one formula works for different strip lengths.
Common Errors & Fixes
#VALUE! or wrong length after RIGHT/LEN
Causes:- Cell contains a number; LEN still works but formula may be mixed with dates.
- N larger than LEN(text) returns empty.
Fixes:- Wrap source in TEXT if needed: TEXT(A2,"@").
- Use MAX(0,LEN(A2)-N) inside RIGHT if N can exceed length in edge cases.
Frequently Asked Questions
How do I remove the first 3 characters in Excel?
=RIGHT(A2,LEN(A2)-3) removes exactly three characters from the left of the text in A2.
How do I remove last N characters instead?
Use LEFT with LEN: =LEFT(A2,LEN(A2)-N). Or see SUBSTITUTE for removing specific characters rather than a fixed count.
Related Formulas
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More