Manuals/calci/EXTRACTNUMBERS

Revision as of 03:07, 31 May 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''EXTRACTNUMBERS(string)'''</div><br/> *<math>string</math> is the string from which you want to extract numbers. ==Description== *EXTRACTNUMB...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
EXTRACTNUMBERS(string)


  • is the string from which you want to extract numbers.


Description

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


Examples

  1. EXTRACTNUMBERS("abc123") = 123
  2. EXTRACTNUMBERS("House Number 4566") = 4566
  3. EXTRACTNUMBERS("how are you?") = (No Output)
  4. EXTRACTNUMBERS("1***%%%1") = 11


See Also


References

String