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 Trainings

Most Popular Movies

Most Popular Movies

Getting produced year of popular films of the IMDB from unformatted title information with year. Also calculating votes ...


Practice: Corrupted data

Practice: Corrupted data

Practice your text functions skills.


Practice: Separation and merge

Practice: Separation and merge

Practice your text functions skills.