Excel Formula to Find the Position of Nth Occurrence of a Character in Text String:
Here we will explain the details on how to Formula Find the Position of Nth Occurrence of a Character from a Text String in Excel Office 365. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Formula Syntax:
- For finding the position of Nth occurrence of a character from a text string in Excel, use the below formula.
=FIND(CHAR(1),SUBSTITUTE($A$4,”e”,CHAR(1),4))
Example:
- In the below Screenshot, we entered the input text string in Cell A4.
- After that, enter the given formula in the selected Formula bar section.
- Finally, the output will be displayed in the selected cell B4.
Explanations for Syntax:
- FIND – In Excel, this function is used to find out the one text string inside the other. It also found out the location of the text and returns the position as a number. Read more onFIND Function.
- CHAR – It will convert the given number into character. Read more onCHAR Function.
- SUBSTITUTE – The main purpose of the SUBSTITUTE Function is to replace the existing text with the new text string from a text string.
Closure:
From this article, you can get some clarification on how to use the formulas for finding the position of the Nth occurrence of a position from a text string in Excel Office 365. Kindly, drop your worthwhile feedback in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!!
Top comments (0)