Manuals/calci/REMOVENUMBERS

REMOVENUMBERS(String)


  • is the string from which numbers are to be removed.


Description

  • REMOVENUMBERS is used to remove numbers from the entered string.
  •   can be a combination of characters, text, numbers etc. entered in double quotation marks.


Examples

  1. REMOVENUMBERS("abc123") = abc
  2. REMOVENUMBERS("House Number 4566") = HouseNumber
  3. REMOVENUMBERS("how are you?") = howareyou?
  4. REMOVENUMBERS("1***%%%1") = ***%%%
  5. REMOVENUMBERS("67a895") = a

Related Videos

Numbers

See Also

References

String