Return numbers only with RegEx on Google Spreadsheet REGEXEXTRACT

Posted on 2014-08-18
Last Modified: 2015-03-02
Hi Experts,

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

I have tried:

Thoughts ?

Question by:Craig Lambie
    LVL 74

    Accepted Solution

    It should just be:


    Open in new window

    LVL 42

    Expert Comment

    by:Rob Jurd, EE MVE
    this works for me: =REGEXEXTRACT(B2,"[0-9]+")
    LVL 1

    Author Closing Comment

    by:Craig Lambie
    Great.  Thanks.
    Of course this was not anywhere on the net, and I couldn't work out the right RegEx combo.

    Thanks a lot.
    LVL 74

    Expert Comment

    by:käµfm³d 👽
    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 = )

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I'm Dumb-phoned(ed) Last week, I noticed this message when adding events to my Google Calendar: On June 27th (2015), Google is removing SMS as a notification option for Google Calendar events.  Their assumption is that enough people have smart p…
    You can provide a virtual interface for remote stakeholders in a SWOT analysis through a Google Drawing template. By making real time viewing and collaboration possible, your team can build a stronger product.
    This Micro Tutorial will demonstrate importing calendar invites from events such as webinars into your Google Calendar.
    This Micro Tutorial will demonstrate using Google Doc how to import live data to another spreadsheet in Google Spreadsheets using the IMPORTRANGE function.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now