Manuals/calci/REMOVETEXT
Jump to navigation
Jump to search
REMOVETEXT(string)
- is the string from which text is to be removed.
Description
- REMOVETEXT is used to remove text from the entered string.
- can be a combination of characters, text, numbers etc. entered in double quotation marks.
Examples
- REMOVETEXT("abc123") = 123
- REMOVETEXT("House Number 4566") = 4566
- REMOVETEXT("how are you?") = (all text removed. hence blank output)
- REMOVETEXT("1***%%%1") = 11
- REMOVETEXT("67a895") = 67895
Related Videos
See Also
References