Difference between revisions of "Manuals/calci/REMOVENUMBERS"
Jump to navigation
Jump to search
Line 19: | Line 19: | ||
==Related Videos== | ==Related Videos== | ||
− | {{#ev:youtube|v=0CgNg6NwQWM|280|center| | + | {{#ev:youtube|v=0CgNg6NwQWM|280|center|Numbers}} |
==See Also== | ==See Also== |
Latest revision as of 15:13, 22 February 2019
REMOVENUMBERS(String)
- is the string from which numbers are to be removed.
Description
- REMOVENUMBERS is used to remove numbers from the entered string.
- can be a combination of characters, text, numbers etc. entered in double quotation marks.
Examples
- REMOVENUMBERS("abc123") = abc
- REMOVENUMBERS("House Number 4566") = HouseNumber
- REMOVENUMBERS("how are you?") = howareyou?
- REMOVENUMBERS("1***%%%1") = ***%%%
- REMOVENUMBERS("67a895") = a
Related Videos
See Also
References