Difference between revisions of "Manuals/calci/EXTRACTNUMBERS"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''EXTRACTNUMBERS(string)'''</div><br/> *<math>string</math> is the string from which you want to extract numbers. ==Description== *EXTRACTNUMB...") |
(No difference)
|
Revision as of 04:07, 31 May 2017
EXTRACTNUMBERS(string)
- is the string from which you want to extract numbers.
Description
- EXTRACTNUMBERS is used to extract numbers from the entered string.
- can be a combination of characters, text, numbers etc. entered in double quotation marks.
Examples
- EXTRACTNUMBERS("abc123") = 123
- EXTRACTNUMBERS("House Number 4566") = 4566
- EXTRACTNUMBERS("how are you?") = (No Output)
- EXTRACTNUMBERS("1***%%%1") = 11
See Also
References