From: {"blab_abc":"DEFGHIJKLMNOPQRSJFUR" To: DEFGHIJKLMNOPQRSJFUR Thank you ![]() |
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!
From: {"blab_abc":"DEFGHIJKLMNOPQRSJFUR" To: DEFGHIJKLMNOPQRSJFUR Thank you ![]() |
Do you expect help without explaining fully what you mean?
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.
Don’t have an account yet? Register yourself now and be a part of our community!