Quotation format for String that contains quotes

I am confused on how to solve the string that contains quotations. It just doesn’t allow me to convert it to a proper string. Please help :slight_smile:

“=IMPORTRANGE(“1RmScaI6sRyyId-YqderhsJvULElbJGiJBDy3U-T1lJA”,“Sheet1!C2:D”)”

@Penganimation, the requirement or question is not clear at all, do you mind giving a bit of detail?

Hi,

Perhaps you should write as the following.

"=IMPORTRANGE(""1RmScaI6sRyyId-YqderhsJvULElbJGiJBDy3U-T1lJA"",""Sheet1!C2:D"")"

Regards,

Wow, that works, thank you so much. I have another string here:
“=FILTER(A:A,ARRAYFORMULA(ISNA(MATCH(A:A,Sheet1!A:A,0))))”

which gives me the following error message.
Write Cell: The data you want to write “=FILTER(A:A,ARRAYFORMULA(ISNA(MATCH(A:A,Sheet1!A:A,0))))” has a wrong format, or Excel is busy. If your data is a formula, make sure you use comma as parameters separator. Please check that you are not editing a value and that no dialog windows are opened.

I just want to check if the format of my string is wrong? or its caused by other reasons?

Hi,

Do you want to write it to excel worksheet? It seems for Google Spreadsheet. (eg Arrayformula)

Regards,

Yes I am trying to write a formula in excel sheet that is meant to be read using Google sheet.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.