0

I have text in the table. I want to check the text whether there is a typo or not. Usually to check my typo using the default Spelling Tool from Google Sheet.

Image

The question is: Can the spelling check be changed to a formula, for example, I type the formula on Cell B3?

= SpelCheck (A2)

When entering, the correct word suggestion results out.

Spreadsheet

  • sheet is private – user0 Feb 15 at 13:34
0

There isn't formula which would correct spelling of value in the cell. Closest you can get is to use DETECTLANGUAGE formula and check if the cell's content is valid grammatically. Something like:

=DETECTLANGUAGE(A3)

which can be then a bit improoved to:

=IF(DETECTLANGUAGE(A3)="en", "ok", "spelling error")

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.