
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 22, 2020 03:16 AM
How can I do a word count of a record?
I have a table to organize what I write divided by scenes and I want to count the words in every scene.
Thanks in advance.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 26, 2020 04:52 PM
Hi @Ana_Capucho, I was looking into this as well today and found this page https://support.airtable.com/hc/en-us/articles/360035351893-Word-and-character-counts
They recommend using LEN({Text Field}) - LEN(SUBSTITUTE({Text Field}, ’ ', ‘’))+1
I’ve only started using it, but it has been working for me. Hope it’s what you’re looking for! :slightly_smiling_face:
Edit: I realized that it doesn’t return 0 for when there’s no text at all (instead it returns 1). So I got around that by modifying the above formula to return 0 when there is no text.
IF(({Text Field}=BLANK()),0,(LEN({Text?}) - LEN(SUBSTITUTE({Text Field},’ ', ‘’))+1))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 26, 2020 04:52 PM
Hi @Ana_Capucho, I was looking into this as well today and found this page https://support.airtable.com/hc/en-us/articles/360035351893-Word-and-character-counts
They recommend using LEN({Text Field}) - LEN(SUBSTITUTE({Text Field}, ’ ', ‘’))+1
I’ve only started using it, but it has been working for me. Hope it’s what you’re looking for! :slightly_smiling_face:
Edit: I realized that it doesn’t return 0 for when there’s no text at all (instead it returns 1). So I got around that by modifying the above formula to return 0 when there is no text.
IF(({Text Field}=BLANK()),0,(LEN({Text?}) - LEN(SUBSTITUTE({Text Field},’ ', ‘’))+1))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 12, 2023 06:56 AM - edited ‎Sep 12, 2023 07:07 AM
This method doesn't work when there are extra spaces at the beginning / end of the text or multiple spaces between words, and this happens so often.
Here is a formula that handles that :
IF(TRIM(REGEX_REPLACE({Text field}, '\\s+', ' '))=BLANK()
,
0
,
LEN(TRIM(REGEX_REPLACE({Text field}, '\\s+', ' ')))
- LEN(SUBSTITUTE(
TRIM(REGEX_REPLACE({Text field}, '\\s+', ' '))
,
' ', ''
))
+ 1
)
