Manuals/calci/REMOVETEXT

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

  1. REMOVETEXT("abc123") = 123
  2. REMOVETEXT("House Number 4566") = 4566
  3. REMOVETEXT("how are you?") = (all text removed. hence blank output)
  4. REMOVETEXT("1***%%%1") = 11
  5. REMOVETEXT("67a895") = 67895

Related Videos

Remove Text

See Also


References

String