Extract Only Numbers Using Formulas In Excel

  • Re: Extract Only Numbers Using Formulas In Excel


    Please refer to the board rules...


    When you post the same issue on more than 1 board, you are required to include links to all your posts for that issue. Basically this is so anyone who may decide to reply can check the issue has not already been resolved, or a similar answer provided, on another board.



    Please reply to this thread listing the URLs of all your other posts for this issue and ensure any future posts by you comply fully with the rules.

  • Re: Extract Only Numbers Using Formulas In Excel


    Quote from cytop;680179

    I'd like to know where you looked... [URL="http://www.google.co.uk/?gws_rd=cr#bav=on.2,or.r_qf.&fp=e1624d921e4bdb10&q=excel%20formula%20extract%20number%20from%20text%20string"]http://www.google.co.uk/?gws_r…er%20from%20text%20string[/URL]


    Thanks for your attention to this issue.
    That's only tells how to extract numbers from a text strings. But i have some different requirement. I want to replace all these characters -,spaces,+91,.,(,) ,& by blank. Please see the below example as well as attachment :
    Sample List :
    ' +91 913-402-5962
    905.493.3041
    9oes4not currently have a phone number
    944 40)&7854 063992

    Extract Only Numbers


    9134025962
    9054933041
    94
    944407854063992

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!