Formula for specific character count in string

[Burner]

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.

[nnnnneil]

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

[Justin_Barrett · Accepted solution]

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}, " ", ""))

[Burner]

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