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
Removes extra spaces.
How TRIM worksTRIMTrim a Name with Extra SpacesPractice removing leading, trailing, and repeated spaces from a short text value.BeginnerNot startedTRIMClean a City LabelUse TRIM on a city name that contains extra spaces around and inside it.BeginnerNot startedTRIMTrim a Product DescriptionApply TRIM to a product description with padded spaces.BeginnerNot startedTRIMTrim a Code with Trailing SpacesRemove unwanted spaces from a short code value.BeginnerNot startedTRIMTrim a Full Address LineUse TRIM to clean an address line containing extra spaces.BeginnerNot startedTRIMTrim Product NamesClean up product names that contain extra spaces between words and at the edges.IntermediateNot startedTRIMTrim and Count CharactersCombine TRIM with LEN to count characters in a cleaned text value.IntermediateNot startedTRIMTrim and ConcatenateJoin a cleaned first name and last name into a single full name.IntermediateNot startedTRIMTrim and UppercaseClean a messy code and convert it to uppercase in one formula.IntermediateNot startedTRIMTRIM + LEN: Count Characters Without Extra SpacesUse TRIM together with LEN to count the characters in a messy text entry after all extra spaces are removed.IntermediateNot startedTRIMClean Customer Name for LookupA sales rep needs the cleaned full name of a customer to match a mailing list, joining first and last names that were entered with stray spaces.AdvancedNot startedTRIMCount Clean Product CodesAn inventory analyst must count how many product codes, once trimmed, match a specific code to verify stock entries.AdvancedNot startedTRIMTotal Sales for Cleaned RegionA regional manager wants the total sales for the region "West" even though region names contain inconsistent spacing.AdvancedNot startedTRIMExtract Cleaned Domain from EmailA marketing analyst needs the domain part of an email address, which may contain stray spaces around the @ symbol.AdvancedNot startedTRIMClean and Capitalize City NameA CRM specialist needs a properly capitalized city name from a field with inconsistent spacing and casing.AdvancedNot started