Difference between revisions of "Manuals/calci/REMOVENUMBERS"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''REMOVENUMBERS( | + | <div style="font-size:30px">'''REMOVENUMBERS(String)'''</div><br/> |
| − | *<math> | + | *<math>String</math> is the string from which numbers are to be removed. |
| Line 6: | Line 6: | ||
*REMOVENUMBERS is used to remove numbers from the entered string. | *REMOVENUMBERS is used to remove numbers from the entered string. | ||
| − | *<math> | + | *<math>String</math> can be a combination of characters, text, numbers etc. entered in double quotation marks. |
Revision as of 17:30, 27 June 2018
REMOVENUMBERS(String)
- is the string from which numbers are to be removed.
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
See Also
References