This site has limited support for your browser. We recommend switching to Edge, Chrome, Safari, or Firefox.

Counting The Number of Times a Keyword Appears in an Airtable Cell

Whether you’re using Airtable to perform keyword research or content analysis, you can use Airtable to calculate the number of times a word appears in an Airtable cell using a formula.


Here is the formula, where {Column} refers to the name of the column the cell of interest is in, and “text” refers to the string of text that you want to count in the cell.

(LEN({Column})-LEN(SUBSTITUTE({Column}, "text", "")))/LEN("text")

Note that the formula above is case-sensitive, so that’s why if you were to look at the screenshot above under the column “this” (lowercase), the keyword counts yield 0 for all rows. To account for keywords in sentence-case only, you would have to change “text” into “Text” in the above formula:

(LEN({Column})-LEN(SUBSTITUTE({Column}, "Text", "")))/LEN("Text")

To account for keywords in both sentence-case and lower-case, you can combine both the above formula this way:

(LEN({Column})-LEN(SUBSTITUTE({Column}, "text", "")))/LEN("text")
+
(LEN({Column})-LEN(SUBSTITUTE({Column}, "Text", "")))/LEN("Text")


Hi, I'm Ryan.

Over the past 10 years, I've lived & worked in 5 cities across 3 countries.

I like helping others to move abroad, and helping them to decide whether they should.

MY VISA GUIDE →

Spark a Conversation

Cart

No more products available for purchase