Difference between revisions of "Manuals/calci/REMOVENUMBERS"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''REMOVENUMBERS(string)'''</div><br/> *<math>string</math> is the string from which numbers are to be removed. ==Description== *REMOVENUMBERS ...") |
|||
| Line 20: | Line 20: | ||
==See Also== | ==See Also== | ||
| + | *[[Manuals/calci/REMOVETEXT | REMOVETEXT]] | ||
*[[Manuals/calci/EXTRACTTEXT | EXTRACTTEXT]] | *[[Manuals/calci/EXTRACTTEXT | EXTRACTTEXT]] | ||
*[[Manuals/calci/EXTRACTNUMBERS | EXTRACTNUMBERS]] | *[[Manuals/calci/EXTRACTNUMBERS | EXTRACTNUMBERS]] | ||
| − | |||
==References== | ==References== | ||
Revision as of 05:08, 1 June 2017
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