Finding a character in a text with SEARCH() function
If you find a character in a text, you use SEARCH () formula.
In the paranthesis of SEARCH () formula, first you write the character in " " or the cell name your character is written.
After, you write the cell name of where the text is written.
Lastly, you write a start number which describes the order of the character you start to search.
If you don't write a start number, default value will be 1.
SEARCH () formula do not have case sensitivity.
The result will be the order of the character in text.
Related Tutorials
 function.png)
, AND() and OR() formulas.png)
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
