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
Last characters.
How RIGHT worksRIGHTLast Two Digits of Order CodesUse RIGHT to pull the last two characters from each order code.BeginnerNot startedRIGHTLast Three Letters of Product CodesExtract the final three characters of a product code using RIGHT.BeginnerNot startedRIGHTLast Character of NamesUse RIGHT with a count of 1 to get the final letter of each name.BeginnerNot startedRIGHTLast Two Characters of DatesPull the day portion from a date stored as text using RIGHT.BeginnerNot startedRIGHTLast Four Digits of Phone NumbersExtract the final four digits of a phone number with RIGHT.BeginnerNot startedRIGHTLast digit of order numbersExtract the final digit of each order ID to use as a check digit.IntermediateNot startedRIGHTTwo-digit year from date textPull the two-digit year from a text date and convert it to a number.IntermediateNot startedRIGHTLast three letters of product codesExtract the three-character category suffix from each product code.IntermediateNot startedRIGHTLast name from full nameExtract the surname from a full name by taking characters after the space.IntermediateNot startedRIGHTLast two digits of sales totalsExtract the last two digits of a sales total as a number.IntermediateNot startedRIGHTExtract Last Two Digits of Invoice NumbersA finance team stores invoice IDs as text and needs the two-digit batch code that appears at the end of each invoice number.AdvancedNot startedRIGHTGet Last 4 Digits of Phone NumbersA CRM analyst wants to verify customer records by pulling the last four digits of each phone number.AdvancedNot startedRIGHTExtract Year Suffix from Project CodesA project manager encodes the start year in the last two characters of each project code and needs it as a number for sorting.AdvancedNot startedRIGHTLast Character as Region FlagA sales report uses a single trailing letter to indicate region, and the analyst needs to isolate that letter for grouping.AdvancedNot startedRIGHTCombine RIGHT with LEN for Suffix LengthA logistics team wants to extract the numeric suffix after the hyphen, whose length varies, by using the position of the hyphen.AdvancedNot started