Exercise catalogue
Choose a category
Pick a topic, then a function. Each exercise opens a real spreadsheet: type the formula, check your answer, and get a hint if you’re stuck.
386 exercises0 completed
Number of characters.
How LEN worksLENCount Characters in Product NamesUse LEN to find how many characters each product name contains.BeginnerNot startedLENLength of City NamesMeasure the number of characters in each city name in a small list.BeginnerNot startedLENCharacter Count of CodesFind the number of characters in product codes that mix letters and digits.BeginnerNot startedLENLength of Email AddressesCount the characters in email addresses stored as plain text.BeginnerNot startedLENCount Characters in a PhraseUse LEN to count all characters, including spaces, in a short phrase.BeginnerNot startedLENCount Characters in a Product CodeUse LEN to find how many characters are in a single product code.IntermediateNot startedLENTotal Characters Across Two CellsCombine LEN with the addition operator to sum characters from two cells.IntermediateNot startedLENCharacters After Removing SpacesUse LEN together with SUBSTITUTE to count characters excluding spaces.IntermediateNot startedLENLongest City Name by Character CountUse LEN inside an IF comparison to flag whether a city name is longer than another.IntermediateNot startedLENCount Characters in a Concatenated LabelUse LEN with CONCATENATE to count characters in a combined label.IntermediateNot startedLENFlag Long Product CodesA warehouse team wants to count how many product codes exceed 10 characters so they can be shortened for scanning labels.AdvancedNot startedLENAverage Name Length of Active CustomersA marketing analyst needs the average length of customer names, but only for customers marked Active.AdvancedNot startedLENTotal Characters in Top-Selling ItemsA sales manager wants the combined character count of item names whose sales exceed 100 units.AdvancedNot startedLENLongest Name Among High-Value AccountsA key-account manager wants the character length of the longest customer name among accounts with revenue above 5000.AdvancedNot startedLENCount Characters in Longest Product NameA product manager wants to know how many characters are in the longest product name on the list.AdvancedNot started