How to Use the LEN Function in Excel (Count Characters in a Cell) The LEN() function in Excel returns the number of characters in a text string, including spaces and special symbols. 📘 Syntax: =LEN(text) ✅ Example: =LEN("ScriptDataInsights") This will return 18 , because the phrase contains 18 characters with no spaces. 🎯 Use Cases: Validate length of phone numbers or codes Check for empty or incomplete fields Build formulas to trim or clean text based on length 💡 Bonus Tip: Use LEN(A1) = 0 to check if a cell is empty (not just visually blank). For more Excel tricks, follow ScriptDataInsights and keep learning!