REMOVENUMBERS
REMOVENUMBERS(value)
Removes all numbers from a text string and removes all spaces at the beginning and end of the result.
| text | The 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
