• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1851
  • Last Modified:

Return numbers only with RegEx on Google Spreadsheet REGEXEXTRACT

Hi Experts,

I am looking for the RegEx code that will work inside the REGEXEXTRACT function on a google spreadsheet.

I have tried:
=REGEXEXTRACT(B2,"\([0-9]*)")
=REGEXEXTRACT(B2,"\([0-9])")
=REGEXEXTRACT(B2,"\[0-9]")

Thoughts ?

Thanks
0
Craig Lambie
Asked:
Craig Lambie
  • 2
1 Solution
 
käµfm³d 👽Commented:
It should just be:

=REGEXEXTRACT(B2,"[0-9]+")

Open in new window

0
 
RobOwner (Aidellio)Commented:
this works for me: =REGEXEXTRACT(B2,"[0-9]+")
0
 
Craig LambieAuthor Commented:
Great.  Thanks.
Of course this was not anywhere on the net, and I couldn't work out the right RegEx combo.

Thanks a lot.
0
 
käµfm³d 👽Commented:
I haven't actually used Google Docs yet, so I had to confirm what they allowed. Their help page shows exactly what I put above = )
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now