How to Use the FIND Function in Excel (Case-Sensitive Search) The FIND() function allows you to locate one text string within another. Unlike SEARCH, FIND is case-sensitive , which makes it useful when exact text patterns matter. 📘 Syntax: =FIND(find_text, within_text, [start_num]) ✅ Example: =FIND("X","Excel") This returns an error because "X" is uppercase and "x" in "Excel" is lowercase. FIND is case-sensitive! 🎯 Use Cases: Finding case-sensitive keywords in strings Checking for exact formatting (e.g., capitalized names or codes) Splitting or extracting specific sections from structured data 🧠 Tips: If you want a case-insensitive version, use SEARCH() instead. For more Excel tips, follow ScriptDataInsights!