REMOVENUMBERS

Removes all numbers from a text string and removes all spaces at the beginning and end of the result.
eg ("8011 LB") returns "LB".


Parameters:
text = The value or cell address from which you want to strip the numbers.


Remarks

* For instructions on how to add a function to a workbook refer to the page under Inserting Functions
* The equivalent JavaScript function is REMOVENUMBERS




© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext