How to Use the FIND Function in Excel (Locate Character Position) The FIND() function helps you locate the position of a specific character or substring within a larger text string. It is case-sensitive and does not allow wildcards. 📘 Syntax: =FIND(find_text, within_text, [start_num]) ✅ Example: =FIND("D", "ScriptDataInsights") This will return 7 because the uppercase "D" is the 7th character in the string. 🎯 Use Cases: Find position of a delimiter like a comma or dash Use with MID or LEFT to extract data dynamically Detect formatting issues in strings 🛑 Important: FIND is case-sensitive. To ignore case, use the SEARCH() function instead. For more Excel insights, follow ScriptDataInsights and master your spreadsheet skills!