Remove First 3 Characters in Excel — Free Formula Generator | SheetMaster

How to Remove First 3 Characters in Excel: Step-by-Step Guide

Stripping unwanted characters from the start of a cell is one of the most common data cleaning tasks in Excel. Whether you are dealing with product codes (e.g. "SKU-12345"), phone numbers with country codes, or imported CSV data with prefix junk, Excel offers three reliable methods to remove the first N characters.

Method 1: RIGHT + LEN (Most Popular)

The most intuitive and widely-used approach:

1. Identify your target cell — e.g. A2 contains "SKU-12345".
2. Apply the formula: =RIGHT(A2, LEN(A2) - 3) removes the first 3 characters.
3. Drag down to apply to all cells in your column.

Why it works: LEN(A2) counts the total length. Subtracting N gives RIGHT the exact number of trailing characters to keep. Change "3" to any number of characters you need to strip.

Method 2: MID (More Forgiving)

If you find RIGHT + LEN confusing, MID offers a more natural "start at character X" syntax:

• =MID(A2, 4, LEN(A2)) — starts at the 4th character, keeping everything after it.
• Replace the "4" with N+1 (where N is the number of characters to remove). For N=3, start at position 4.

Method 3: REPLACE (One-Step)

For removing a known prefix string (not a fixed character count), use REPLACE:

• =REPLACE(A2, 1, 3, "") — replaces the first 3 characters with an empty string.
• This is simpler than RIGHT+LEN when you always remove the same fixed count.

Method Comparison Table

Real-World Use Cases

• Cleaning product codes: Remove prefix "SKU-" from "SKU-12345" → =RIGHT(A2,LEN(A2)-4).
• Phone numbers: Strip country code "+1" from "+15551234567" → =RIGHT(A2,LEN(A2)-2).
• CSV imports: Remove quote character or "#" prefix from imported data.
• Serial numbers: Drop fixed-length batch prefix from part numbers.
• Date formatting cleanup: Strip leading zeros or prefixes from imported date strings.

Variable N — One Formula for Any Strip Length

Instead of hard-coding the number, store it in a cell reference:

=RIGHT(A2, LEN(A2) - D1)

Where D1 contains the number of characters to remove (e.g. 3, 5, 7). Update D1 once and every formula using it recalculates. This is especially powerful when processing datasets with varying prefix lengths.

Edge Cases & How to Handle Them

• N is larger than text length: RIGHT returns empty. Wrap with =IF(LEN(A2)<=3, A2, RIGHT(A2,LEN(A2)-3)) to return the original value unchanged.
• Cell contains a number (not text): LEN still works, but if you get #VALUE!, wrap with =RIGHT(TEXT(A2,"@"), LEN(TEXT(A2,"@"))-3).
• Whitespace differences: Use TRIM before stripping: =RIGHT(TRIM(A2), LEN(TRIM(A2))-3) to avoid off-by-one errors from trailing spaces.
• Empty cells: RIGHT returns empty. Use =IF(A2="", "", RIGHT(A2,LEN(A2)-3)) to keep your output clean.