VBA Code for Extracting Numbers

    I have situation as mentioned below. I want to extract isnumber from column 1 and put in column 2 as can seen in picture.

    ikl;knkjnnn749000sk749000
    ergheqrh550000sb550000
    rg100erg0000rgh1000000
    erger900000greh900000
    erg600000rg600000
    5erger00000ergerg500000
    fgb80000gg0rff800000
    fgwe6ewfgw1gweg61
    g50000f0w500000
    wef3wef1330weg31330
    gwe23000002300000
    800000ewgweg800000
    egwweg13000wegwe001300000
    sdg13636ghj13636.36
    36000sd36000
    sdg500000500000
    sdgsdg5250052500

    Thanks for your Like :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Thanks for both your Thanks ...AND for the Like :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1

    Here is problem that after decimal it should not count number but it is please check.


    749000INR 749000
    shoaib550000kn 550000
    1000000 1000000
    900000 INR tkh 900000
    Rslom 600000 kbl 600000
    500000 500000
    800000 800000
    61.000,00 6100000
    500000 500000
    US $ 31330.00 3133000
    2300000 2300000
    800000 800000
    Rs. 1300000 1300000
    13636.36 1363636
    INRLacs or US$36000 36000
    INR 500000 500000
    52500.00 USD 5250000
    Quote from ShoaibRajput1

    Carim,


    Same question but now i want to extract ISTEXT from cell please share VBA.


    Attached is a method to strip numbers


    Hope this will help

    Carim,


    Its not working please check. First row answer should be 749 instead of 749000


    ikl;knkjnnn749.000sk 749000
    ergheqrh550000sb 550000
    rg100erg0000rgh 1000000
    erger900000greh 900000
    erg600.000rg 600000
    5erger000.00ergerg 500000
    fgb80000gg0rff 800000
    fgwe61.000,00ewfgweg 61000
    g50000f0w 500000
    wef3wef1330weg 31330
    gwe2300000 2300000
    800000ewgweg 800000
    egwweg13000wegwe00 1300000
    sdg13636ghj 13636
    36000sd 36000
    sdg500.000 500000
    sdgsdg52500 52500

    Hello,


    Please clarify your definition of decimal separator ...


    On the first row ... it is a point ...


    and on row # 8 ... it is a comma ...


    :S

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1

    Glad you could fix your problem :)


    Thanks for your Thanks

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    This has been cross-posted on at least one other forum. Please provide cross-post links, as required by this forum's rules. Thanks.


    NO FURTHER HELP until this has been done, please.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

    AliGW


    Thanks a lot for pointing out this fact ...:)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Thank Fluff, who reported it. :)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

    Quote from AliGW

    Thank Fluff, who reported it. :)


    Only saw your message ...;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

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

Register Yourself Login