Delete all numbers in selection (0-9)

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

Text › 17. Delete all numbers in selection (0-9)

This utility will remove all numbers from the values in the selected cells.

The numbers 1, 2, 3, 4, 5, 6, 7, 8, 9 and 0 will be removed from every cell in your selection. Cells with a formula will be skipped.
If you have selected only one single cell then the utility will edit all the cells on your worksheet.

For example a cell with the value '8011LB' will be replaced with LB'.

Screenshots

Text › 17 Delete all numbers in selection (0-9)

Starting this tool

Click ASAP Utilities › Text › 17. Delete all numbers in selection (0-9)
Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...

Additional keywords for this tool:
Remove, delete, 0123456789

Delete all text characters (a-z) in selected cells

Remove ending carriage return (Alt+Enter)

Download

©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

Empowering Excel Users Worldwide for 25 Years