|
|
You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語Text » Delete all numbers in selection
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
Starting this utility
In the Excel menu choose: ASAP Utilities » Text » Delete all numbers in selection« Return to the list of “Text” tools.
| « Previous Delete all text characters (a-z) in selected cells | Next » Remove ending carriage return (Alt+Enter) |
 - 750px - ribbon.png "Download ASAP Utitilities")
Download ASAP Utilities
Additional keywords for this tool:
Remove, delete, 0123456789
Remove, delete, 0123456789
Follow ASAP Utilities on Facebook
© 1999-2018 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
