How to Count Words Containing 'and' in Google Docs

When it comes to creating, editing, and collaborating on documents online, Google Docs is an ideal choice. With its impressive selection of formatting options and seamless sharing capabilities, it's no wonder why it's the most popular free online word processor available. However, sometimes we need to count the number of words containing a specific term in our document. In this article, we'll explore how to do just that using Google Docs.

To start, press Ctrl + Shift + C to access the word count pop-up window instantly. If you want to reopen the word count at any time, simply use this shortcut again. Google Docs presets a range of useful keyboard shortcuts to help you access tools quickly.

To get the word count for 'and', we need to divide 9 (the total characters for instances of and in the cell) by the number of characters in the word 'and' which is 3. To do this, use the Ctrl + Shift + C keyboard shortcut. So, in the end, the number we get includes all characters containing 'and' in each row.

In our example, the total number of characters is 315. Finally, all of the characters not containing the word 'and' are subtracted from the string length. To do this, we use the LEN function to count the number of characters in the cell excluding instances of “and”. We then eliminate all the occurrences of 'and' and replace them with empty strings ('') using the SUBSTITUTE function.

This formula uses LOWER(D20) to convert everything in cell D20 to lowercase. Since LEN is a case-sensitive function in Google Sheets, we need to ensure all text we intend to find is either upper case or lower case. To ensure this, we convert all the words into either upper case or lower case.

Once we've done this, we can use the LEN function to get the total number of characters in the cell. By subtracting the length of the string without 'and' from the total length, we get the word count for 'and'.

In conclusion, counting words containing a specific term like 'and' in Google Docs is a straightforward process that requires some basic knowledge of keyboard shortcuts and functions. With these steps, you can easily achieve your desired result.

Word Count Good Docs

In this article, we've demonstrated how to use Google Docs to count the number of words containing a specific term. By following these simple steps, you can apply this technique to any document in Google Docs. Whether you're creating a report, writing an essay, or collaborating on a project with others, Google Docs provides an ideal platform for your needs.

Woud count good docs