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,

  • 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.

    Bruce :cool:

  • Re: Extract dollar amount from cell

    Try this. :cool:

    Bruce :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:

    Bruce :cool:

  • Re: Extract dollar amount from cell


    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


Participate now!

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