Difference between revisions of "Manuals/calci/REMOVETEXT"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''REMOVETEXT(string)'''</div><br/> *<math>string</math> is the string from which text is to be removed. ==Description== *REMOVETEXT is used to...") |
|||
| Line 17: | Line 17: | ||
#REMOVETEXT("67a895") = 67895 | #REMOVETEXT("67a895") = 67895 | ||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=W_defvKTiVc&t=7s|280|center|Remove Text}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 12:38, 4 April 2019
REMOVETEXT(string)
- is the string from which text is to be removed.
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