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...") |
|||
| Line 16: | Line 16: | ||
#EXTRACTNUMBERS("1***%%%1") = 11 | #EXTRACTNUMBERS("1***%%%1") = 11 | ||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=bqsvOygpQWc|280|center|Numbers}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 15:05, 21 March 2019
EXTRACTNUMBERS(string)
- is the string from which you want to extract numbers.
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
Related Videos
See Also
References