Finding a character in a text with FIND() function

If you find a character in a text, you use FIND() formula.

In the paranthesis of FIND() 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.

FIND() formula has 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: Arrangement

Practice: Arrangement

Practice your text functions skills.