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.