How to count misspelled words in a google sheets cell

Question

Is there a way to count misspelled words in a google sheets cell?

If cell A1 contains 'hello. ther are a lot of missspelleed wrds in ths cell' and I put the formula in A2, I'd like the formula to return a 4 in A2 for the 4 misspelled words in A1.

I've tried this but only received a 1 in A2: =SUM(IF(ISERR(SPELLING(SPLIT(A1, " "))), 1, 0))

and this: =ARRAYFORMULA(SUM(IF(ISERR(SPELLING(SPLIT(A1, " "))), 1, 0)))

I want to apply the formula to all the cells in one column.

Thanks

Answer 1

There is no native function for testing spelling of text in a spreadsheet.

However, there is a script for a custom formula in GitHub (courtesy of Vance): https://github.com/caesiumtea/sheets-spellcheck

Load the script and use this formula: =counta(split(SPCHECK(A1)," "))

---

SAMPLE