Count the Occurrences of a Character in a String in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstocounttheoccur, kutools
Published: 2020-10-08 08:03:38

---
title: Count the Occurrences of a Character in a String in Excel Office 365!!
published: true
date: 2020-10-07 04:00:49 UTC
tags: KutoolsExcelTutorial,StepstoCounttheOccur,Kutools
canonical_url: https://geekexcel.com/count-the-occurrences-of-a-character-in-a-string-in-excel-office-365/
---

In this post, you will understand the steps to **Count the Occurrences of a Character in a String in Excel Office 365** using **Kutools.** Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Count the Occurrences of a Character in a String:

To count the occurrences of a character in a string, do as below steps.

- Take the below example data to count the letter “ **e** ” which appears in the **cell B2**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-9.png)<figcaption id="caption-attachment-15276">Example</figcaption>

- You need to **select an empty cell** to display the result.
- On the **Kutools Tab, select** the **Kutools**  **Functions** option, **choose** the **Statistical & Math** option from the drop-down list, **select** the **COUNTCHAR** option.

### Note:

- **COUNTCHAR function** counts the number of times a character occurs in a text and this function is **case** – **sensitive**.

![Choose COUNTCHAR option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-COUNTCHAR-option.png)<figcaption id="caption-attachment-15277">Choose COUNTCHAR option</figcaption>

- It will open the **Function Arguments dialog box.**
- **Within\_text** – you need to select the cell in which you want to count the specific character.
- **Find\_text** – you need to enter the character that you want to count the occurrences.

![Function Arguments dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Function-Arguments-dialog-box-2.png)<figcaption id="caption-attachment-15278">Function Arguments dialog box</figcaption>

- Finally, **click** the **OK** button to get the result.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-10.png)<figcaption id="caption-attachment-15279">Output</figcaption>

## A Brief Summary:

In this article, you can clearly understand the steps to **Count the Occurrences of a Character in a String in Excel Office 365** using **Kutools.** Leave your **queries/suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Find and Fill Missing Numbers in a Sequence in Excel](https://geekexcel.com/find-and-fill-missing-numbers-in-sequence-in-excel-office-365/)
- [Calculate Age By Date of Birth in Excel](https://geekexcel.com/how-to-calculate-age-by-date-of-birth-in-excel-office-365/)