+15Hi. 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.
Best answer by Justin_Barrett
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}, " ", ""))
+21Compare 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}, " ", ""))
+15Compare 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}, " ", ""))Excellent! Just what I needed. Thank you, Justin. :thumbs_up:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.