How to use the Find function In Excel In this tutorial, we want to find the character of ‘ Pig.’ We are going to click the cell where we want to find the character. Then type =Find; bracket.

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER() and TEXTBEFORE() in this tutorial.

If you want to find something while ignoring case sensitivity, use the SEARCH function instead. It has a similar syntax to the FIND function. =SEARCH (search_text, text_to_search_in, [start_position]) ...