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
Joins text with a separator.
How TEXTJOIN worksTEXTJOINJoin product names with commasUse TEXTJOIN to combine a short list of product names into one comma-separated string.BeginnerNot startedTEXTJOINJoin city names with a slashCombine a list of city names into a single string separated by slashes.BeginnerNot startedTEXTJOINJoin first and last namesUse TEXTJOIN with separate cell arguments to build full names.BeginnerNot startedTEXTJOINJoin numbers with a hyphenTEXTJOIN converts numbers to text and joins them with hyphens.BeginnerNot startedTEXTJOINJoin items and skip blanksShow how ignore_empty skips blank cells when joining a list.BeginnerNot startedTEXTJOINJoin product names with a commaCombine a list of product names into one comma-separated string while skipping blanks.IntermediateNot startedTEXTJOINJoin city names with a dashJoin a column of city names using a dash separator and skip empty entries.IntermediateNot startedTEXTJOINJoin first and last names with a spaceCombine first and last names from two columns into full names separated by semicolons.IntermediateNot startedTEXTJOINJoin numbers above a thresholdUse TEXTJOIN with IF to join only the numbers greater than 50.IntermediateNot startedTEXTJOINJoin unique departments alphabeticallyUse TEXTJOIN with UNIQUE and SORT to list distinct departments in alphabetical order.IntermediateNot startedTEXTJOINRegion Summary LineBuild a one-line summary of total sales per region using TEXTJOIN with SUMIF.AdvancedNot startedTEXTJOINTop Seller NamesList names of salespeople who exceeded a threshold, joined by commas.AdvancedNot startedTEXTJOINProduct Code LabelsCombine product code and category into labeled entries joined by semicolons.AdvancedNot startedTEXTJOINMonthly Totals LineSummarize each month's total with SUMIF and join into one sentence.AdvancedNot startedTEXTJOINUnique Cities ListJoin unique city names from a list, skipping duplicates, using TEXTJOIN with UNIQUE.AdvancedNot started