Manuals/calci/EXTRACTNUMBERS
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