Manuals/calci/EXTRACTNUMBERS
EXTRACTNUMBERS(string)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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