How do I only keep what is written in between double quotations

  • I want to create a macro that extracts data located in between the second double quotation in column A sheet 1 and paste it into column 1 sheet 2.


    I have a column filled with entries where {"blab_abc": is the only constant and what changes is the data in between the second pair of double quotations.


    I'm looking for a formula that will copy data in sheet 1 column A and only paste data between second double quotation in sheet 2 column A


    In other words I want to get rid of the first 13 characters and the very last character

  • =MID(Sheet1!A1,14,len(Sheet1!A1)-14)


    should work.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

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