logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Monday March 16th, 2026

Tip of the Day | Monday March 16th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Remove First X Characters...

This tool removes a specified number of characters from the beginning of the selected cells.
It's useful when cleaning up imported data and quickly removing fixed prefixes, codes, or extra characters from values such as product IDs, invoice numbers, or department codes.
It works with both text and numbers.
Formulas are replaced with their calculated values before processing.
Cells that contain dates are skipped.
Examples where you specified to remove the first X characters:
  • "INV/20230405" → "20230405" (removed 4 characters)
  • "PROD_ABC123" → "ABC123" (removed 5 characters)
  • "EMP001234" → "001234" (removed 3 characters)
  • "DEPT:Marketing" → "Marketing" (removed 5 characters)
    Unlike Excel's LEFT, MID, or RIGHT functions, this tool offers a fast, one-click solution without formulas.

    Screenshots

    Example screenshot: Delete leading characters
    Delete leading characters

    Starting this tool


    Text  ›  Remove First X Characters...

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.