How to Escape Quotes in Google Sheets(Quick & Easy Guide)

In this tutorial, you will learn How to Escape Quotes in Google Sheets.

To Escape Quotes in Google Sheets you can use the below methods :

To Escape Quotes in Google Sheets you can use the following approach

=CONCATENATE(CHAR(34),A2,CHAR(34))

The following examples show how to use each method in practice with the following list of strings in Google Sheets:

The below example shows how to use the CONCATENATE function on a list of String :

To enclose the string in double quotes, enter the following formula into cell B2:

=CONCATENATE(CHAR(34),A2,CHAR(34))

Press Enter

Confirm Auto-fill to apply the formula on the remaining cells in the Column.

You’ll see that each cell in column B contains, encircled in double quotes, the corresponding cell from column A.

In the current Unicode table, the function CHAR(34) translates to double quotes.

As a result, this formula concatenates one double quotation at the start and another double quote at the end of the string in column A.

Approach 2: Wrap Quotes Around Quotes

=CONCATENATE("""",A2,"""")

To enclose the string in double quotes, enter the following formula into cell B2:

=CONCATENATE("""",A2,"""")

Press Enter and Confirm Auto-fill to apply the formula to the remaining cells in the Column.

You’ll see that each cell in column B contains, encircled in double quotes, the corresponding cell from column A.

In the above tutorial, we have shown you two methods using which you can Escape Quotes in Google Sheets.

We hope this tutorial was useful.