How to extract number from a string – google sheets

on

Sample usage to remove string prefix and extract remaining number in suffix. 

=REGEXEXTRACT("Rs 157", "\d+")

The outcome will be

157

Suggested posts:

  1. AngularJS format date using date filter
  2. Java – two dimensional array example
  3. Javascript – string starts with check
  4. wget handy commands
  5. How to remove xmlrpc from wordpress headers
  6. CSS border-width – set element border width of four sides
  7. CSS type selectors – define style by element name
  8. Verify a web site in google search console (webmaster tools)
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged , ,