Find Position of Nth Occurrence of a Character in Text String in Excel!!
Tags: findthepositionofnth, kutoolsexceltutorial, kutools
Published: 2020-09-23 06:58:53

---
title: Find Position of Nth Occurrence of a Character in Text String in Excel!!
published: true
date: 2020-09-22 12:21:40 UTC
tags: FindthePositionofNth,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/find-position-of-nth-occurrence-of-a-character-in-text-string-in-excel/
---

## Find Position of Nth Occurrence of a Character in Text String in Excel:

In this article, we are going to see how to **Find the Position of N<sup>th</sup> Occurrence of a Character in Text 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.

## **Steps**  **to Find the Position of N<sup>th</sup> Occurrence of a Character in Text String:**

To find the position of N<sup>th</sup> Occurrence of a character in a text string in Excel, do as below instructions.

- Let’s take an example to know how to do this. The below image has shown the example text string in the **cell**  **A4** , and we are going to **find the 4<sup>th </sup>occurrence of a character “e”.**

![Example Text string](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-88.png)<figcaption id="caption-attachment-14450">Example Text string</figcaption>

- You need to **select the blank cell** then, on the **Kutools** tab, **Choose** the **Formula**  **Helper** option, and **select** the **Formula**  **Helper** option from the menu.

![Select Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-79.png)<figcaption id="caption-attachment-14451">Select Formula Helper option</figcaption>

- It will open the  **Formula**  **Helper dialog box.**
- In that dialog box, **select** the **Find where the character appears N<sup>th </sup>in a string**  option from **Choose**  **a**  **Formula** box.
- You can **check** the **filter** box and **enter**   **n<sup>th </sup>** into the text box to filter the formula quickly.
- Then, in the **String**  **box** , you need to specify the cell from which you want to find the nth occurrence of a character.
- In the **Character**  **box** , you need to enter the character that to want to find.
- In the **Nth Occurrence box** , you have to enter the number of the n<sup>th </sup>occurrence of a character.
- Finally, hit the **Ok** button.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-40.png)<figcaption id="caption-attachment-14452">Formula Helper Dialog Box</figcaption>

- Now, you can see the result as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-18.png)<figcaption id="caption-attachment-14453">Result</figcaption>

## **Closure:**

In this post, you can learn the steps to **Find the Position of N<sup>th</sup> Occurrence of a Character in Text String** in **Excel Office 365** using **Kutools**. Give your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!