Quotation format for String that contains quotes

Help
,
1

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”)”

1 Like
2

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

3

Hi,

Perhaps you should write as the following.

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

Regards,

4

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?

5

Hi,

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

Regards,

6

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

7

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