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.
How CONCAT worksCONCATJoin First and Last NameUse CONCAT to combine a first name and a last name into a full name.BeginnerNot startedCONCATCombine City and CountryJoin a city and its country with a comma and space using CONCAT.BeginnerNot startedCONCATJoin Product Code and NumberCombine a text product code with a numeric item number using CONCAT.BeginnerNot startedCONCATBuild a Full Address LineJoin street, city, and postal code into one address line with CONCAT.BeginnerNot startedCONCATJoin Date and EventCombine an event name with its date using CONCAT.BeginnerNot startedCONCATJoin first and last name with a spaceCombine a first name and a last name into a full name using CONCAT with a literal space as an optional argument.IntermediateNot startedCONCATConcatenate a code and a numberJoin a text code with a numeric ID using CONCAT, which converts the number to text automatically.IntermediateNot startedCONCATJoin city and country with a commaCombine two text cells with a comma and space using CONCAT's optional arguments.IntermediateNot startedCONCATCONCAT with UPPER for a formatted labelNest the UPPER function inside CONCAT to join an uppercased department name with a numeric code.IntermediateNot startedCONCATCONCAT with LEN to build a summaryCombine a product name with a computed character count using CONCAT and the LEN function.IntermediateNot startedCONCATSales Summary SentenceProduce a one-line summary combining the salesperson name with total sales rounded to whole dollars.AdvancedNot startedCONCATCustomer Order Reference CodeBuild a unique order reference by combining a customer's region code, order number, and order year.AdvancedNot startedCONCATFull Name with InitialCreate a display name combining the first initial, a period, and the last name in uppercase.AdvancedNot startedCONCATProduct Label with PriceGenerate a shelf label combining the product name and its price formatted to two decimals with a dollar sign.AdvancedNot startedCONCATEmployee ID Badge TextCombine department abbreviation, employee number, and hire month into a badge string.AdvancedNot started