Formula for specific character count in string

Hi. I’m new to Airtable and trying to find a formula that will count the number of spaces in a string. For example, when this formula is applied to the string “How are you doing?”, I want the formula to return 3. I tried using the FIND function, but all that does is to find the position of the first instance of, say, a space in this example. I’m looking for a formula to count the number of spaces.

Thank you.

Hey @Burner918,
Check out @W_Vann_Hall’s code at Count multiple keywords in text
Cheers,
Neil

1 Like

Compare the length of the original string with the length of a string that’s had all the spaces removed using the SUBSTITUTE() function:

LEN({String Field}) - LEN(SUBSTITUTE({String Field}, " ", ""))
1 Like

Excellent! Just what I needed. Thank you, Justin. :+1:

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