Tip of the Day | Saturday 27 June 2026

This tool removes a specified number of characters from the end of the selected Excel cells.

It's useful when cleaning up imported data and quickly removing suffixes, trailing codes, or extra characters from values such as product IDs, file names, serial numbers, or labels.

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 last X characters:

• "IMG_00321.jpg" → "IMG_00321" (removed 4 characters)
• "Sales_Jan_Report_v5" → "Sales_Jan_Report" (removed 3 characters)
• "8012 WT" → "8012" (removed 3 characters)
• "Invoice_12345_copy" → "Invoice_12345" (removed 5 characters)

Unlike Excel's LEFT, MID, or RIGHT functions, this tool offers a fast, one-click solution without formulas.

Starting this tool