---
title: "Google Sheets: Get the Number of Words or Sentences in a Cell (Paragraph) – Yagisanatode"
author: "Sourabh Choraria"
date: 2020-04-04T08:39:19+00:00
canonical_url: https://pulse.appsscript.info/p/2020/04/google-sheets-get-the-number-of-words-or-sentences-in-a-cell-paragraph-yagisanatode/
markdown_url: https://pulse.appsscript.info/p/2020/04/google-sheets-get-the-number-of-words-or-sentences-in-a-cell-paragraph-yagisanatode.md
categories:
  - "Sheets"
  - "Solutions"
tags:
  - "@LifeOfSpy"
  - "yagisanatode.com"
featured_image: https://pulse.appsscript.info/files/2020/04/Number-of-Words-and-Sentences-in-a-Paragraph-Google-Sheets.jpg
description: "Have you ever woken up in the middle of the night thinking – phawh! I’d really like to know how many words there are in a paragraph – Or stopped mid-chew on some arbitrary item..."
---

# Google Sheets: Get the Number of Words or Sentences in a Cell (Paragraph) – Yagisanatode

![Google Sheets: Get the Number of Words or Sentences in a Cell (Paragraph) – Yagisanatode](https://pulse.appsscript.info/files/2020/04/Number-of-Words-and-Sentences-in-a-Paragraph-Google-Sheets.jpg)

[![](https://pulse.appsscript.info/files/2020/04/Number-of-Words-and-Sentences-in-a-Paragraph-Google-Sheets.jpg)](https://yagisanatode.com/2020/04/04/google-sheets-get-the-number-of-words-or-sentences-in-a-cell-paragraph/)

> Have you ever woken up in the middle of the night thinking – phawh! I’d really like to know how many words there are in a paragraph – Or stopped mid-chew on some arbitrary item carelessly left in the paddock by the boss and thought – geez! If there was only a way to count the number of sentences in a paragraph in a cell in Google Sheets!?

In this short tutorial, Yagisanatode will show you how to get the total count of words in a cell and the total count of sentences in a cell in Google Sheets. They even have a how-to on getting the average sentence length in a paragraph.

Source: *[Google Sheets: Get the Number of Words or Sentences in a Cell (Paragraph) – Yagisanatode*](https://yagisanatode.com/2020/04/04/google-sheets-get-the-number-of-words-or-sentences-in-a-cell-paragraph/)

---

*Published by [Sourabh Choraria](https://pulse.appsscript.info/p/author/scriptgs/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/04/google-sheets-get-the-number-of-words-or-sentences-in-a-cell-paragraph-yagisanatode/](https://pulse.appsscript.info/p/2020/04/google-sheets-get-the-number-of-words-or-sentences-in-a-cell-paragraph-yagisanatode/)*