Table of Contents
To extract text between quotes in Google Sheets, you can use the “MID” function. This function allows you to specify the starting point and number of characters to extract from a specific cell. In this case, you would need to use the “FIND” function to determine the starting point of the text within the cell and then use the “LEN” function to determine the number of characters to extract. By combining these functions, you can easily extract the text between quotes in Google Sheets.
You can use the following formulas in Google Sheets to extract all text in a cell between quotes:
Method 1: Extract Text Between Double Quotes
=REGEXEXTRACT(A2,"""(.*)""")
Method 2: Extract Text Between Single Quotes
=REGEXEXTRACT(A2,"'(.*)'")
Both examples extract the text between the quotes from cell A2.
The following examples show how to use each method in practice.
Example 1: Extract Text Between Double Quotes in Google Sheets
Suppose we have the following list of athletes with their nicknames in double quotes:
Now suppose we would like to extract the text between the double quotes for each athlete.
We can type the following formula into cell B2 to extract the text between the double quotes in cell A2:
=REGEXEXTRACT(A2,"""(.*)""")
We can then click and drag this formula down to each remaining cell in column B:
Column B now contains the text between the double quotes for each corresponding cell in column A.
Example 2: Extract Text Between Single Quotes in Google Sheets
Now suppose we would like to extract the text between the single quotes for each athlete.
We can type the following formula into cell B2 to extract the text between the single quotes in cell A2:
=REGEXEXTRACT(A2,"'(.*)'")
We can then click and drag this formula down to each remaining cell in column B:
Column B now contains the text between the single quotes for each corresponding cell in column A.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets: