Jump to navigation Jump to search
- is the string from which text is to be removed.
- REMOVETEXT is used to remove text from the entered string.
- can be a combination of characters, text, numbers etc. entered in double quotation marks.
- 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