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