ASAP Utilities: Delete all numbers or text characters (a-z) in selection

ASAP Utilities: Delete all numbers or text characters (a-z) in selection

Did you know… you can remove all numbers or text characters (a-z) from the values in the selected cells?

 

Text » Delete all numbers in selection   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 Example screenshot: Delete all numbers in selection

Text » Delete all text characters (a-z) in selected cells All letters from the alphabet (abcdefghijklmnopqrstuvwxyz), both uppercase and lowercase 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 '8011'. Screenshots Example screenshot: Delete all text characters in selection

 

 

If you have any questions, please feel free to contact me!  If you would like to be removed from the distribution just let me know!

 

 

Saved Email location:

\\ffx-filer1a\contracts\Program Support\Helpful Hints

 

 

 

Thank you for your time and attention,

 

A wholly-owned subsidiary of The Boeing Company

Ashley Hill Business Analyst Lead Business Management   703.828.2123 703.322.0885 (Fax) Ashley.Hill@argonst.com

 

“Hard work pays off at the end and if it doesn’t then it’s not the end”

 - Unknown