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

blablamaster · May 20th 2021

From:
{"blab_abc":"DEFGHIJKLMNOPQRSJFUR"

To:
DEFGHIJKLMNOPQRSJFUR

Thank you

**royUK** · May 20th 2021

Do you expect help without explaining fully what you mean?

blablamaster · May 20th 2021

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

**rory** · May 20th 2021

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

should work.

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

Participate now!

Share

Tags