Extract dollar amount from cell

  • Hi folks,


    I need help for Extracting dollar amounts from cell.


    I have done one code but that code extract only 4 digit values !


    For example $5000 if my excel have $15000 it track only $15! can any one say where I miss?


    Here is my code FYI......



    Thanks & Regards,
    dev

  • Re: Extract dollar amount from cell


    You should upload a workbook with the data that your regex is not working with.


    Just in case you don't know how to do that.


    When you click reply there will be a new button labeled go advanced, click on that button then there will be a paperclip icon in the toolbar, click on that icon and follow the instructions.

  • Re: Extract dollar amount from cell


    Try this. :cool:

  • Re: Extract dollar amount from cell


    I am not a regex expert, but I want to be.
    So this seems to work, but may be flawed or there may be a better way to do this.
    Try it out and if you have any problems let me know, I'm looking to better my regex knowledge. :cool:

  • Re: Extract dollar amount from cell


    Hi,


    I have problem for extracting $ amount and percentage. Because I have used multiple patterns for extract amount!




    This code producing wrong result!


    I want extract same order which is in cell ! if % comes first then extract!!! Hope You understand! Please find the attachment! FYI



    regards,
    Dev

Participate now!

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