SEE: 3 Ways to Suppress 0 in Excel. How to use the FIND() function. Excel’s FIND() function parses a substring by finding the position of a specific character or string. This function uses the ...

FIND . The FIND Function in Excel returns the numerical position of a specified character or string (sequence of characters) ...

Click OK: Press OK to apply the function and see the ranking result. How to Use Excel Ranking Function To use the RANK function, you first need to understand its syntax.