The ASAP Utilities menu in Excel (English)
Remove Last X Characters...
ASAP Utilities › Text › 20. Remove Last X Characters...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:
Screenshots
Example screenshot: Delete characters from the end
Starting this tool
- Click ASAP Utilities › Text › 20. Remove Last X Characters...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
Remove last characters, Delete characters at end of cell, Truncate text, Remove suffix from cell, Cut off end of text, Remove ending characters, Trim text at the end, Remove file extension, Remove last X characters, Delete trailing text, Remove trailing characters, Remove last letters or digits, Delete fixed number of characters at end, Crop end of string, Trim suffix from data, Remove ending string from cell
Remove last characters, Delete characters at end of cell, Truncate text, Remove suffix from cell, Cut off end of text, Remove ending characters, Trim text at the end, Remove file extension, Remove last X characters, Delete trailing text, Remove trailing characters, Remove last letters or digits, Delete fixed number of characters at end, Crop end of string, Trim suffix from data, Remove ending string from cell
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Remove First X Characters... |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.