REMOVENUMBERS

REMOVENUMBERS(value)
Removes all numbers from a text string and removes all spaces at the beginning and end of the result.

textThe value or cell address from which you want to strip the numbers.

REMARKS
eg ("8011 LB") returns "LB".


MORE FUNCTIONS
ADDNUMBERS Returns the sum of a group of numbers.
EXTRACTNUMBERS Returns only the numbers from a text string.
REVERSE Returns the characters of a text string in reverse.
SCRAMBLE Returns the characters of a text string with all the characters in a random order.


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