PK !q@= = [Content_Types].xmlPK ! PK !{ docProps/core.xmlTRIM Practice WorkbookXplorExcel.comFree TRIM practice sheets with answer key — https://xplorexcel.com/trim-and-clean-functions-in-excel/PK !0 docProps/app.xmlXplorExcel Practice BuilderPK ! xl/workbook.xmlPK !h h xl/_rels/workbook.xml.relsPK !bI
xl/styles.xmlPK !#Vu u xl/worksheets/sheet1.xml0
1
23
45
|
6
78
910
1112
1314
|
15
1617
1819
2021
|
2223
PK ! # xl/worksheets/_rels/sheet1.xml.relsPK !% xl/worksheets/sheet2.xml24
25262728
129TRIM(C4)LEN(TRIM(C4))
230TRIM(C5)LEN(TRIM(C5))
331TRIM(C6)LEN(TRIM(C6))
432TRIM(C7)LEN(TRIM(C7))
533TRIM(C8)LEN(TRIM(C8))
34
35
36
37
38
PK !_* * xl/worksheets/sheet3.xml3940
25264128254243
12914445
23024645
331347
432
53348
649
750
851
952
1053
PK !puM xl/worksheets/sheet4.xml5440
25555657254243
1295815945
23060261
33162
48
PK !2~" xl/worksheets/sheet5.xml13
63
6425426566
91446758
9246686
9347699
111597071
112617273
PK !mn5 5 xl/sharedStrings.xmlTRIM — Practice WorkbookXplorExcel.com · free Excel tutorials and practice filesLessonTRIM and CLEAN Functions in ExcelAll Excel lessonshttps://xplorexcel.com/excel-tutorial/What’s insideIllustrationA fully worked example. Click any cell to see the formula.Practice Sheet 1Names exactly as they arrived — spaces, capitals and all.Practice Sheet 2Two lists that should match but do not. Prove why.Answer KeyEvery answer plus the exact formula that produces it.How to use it1Read the lesson first, then open the Illustration sheet.2Work through each Practice Sheet. Type formulas into the shaded cells.3Only then open the Answer Key. Compare your formula, not just your number.LicenceFree to use and share for personal study and classroom teaching. Please link back rather than re-hosting the file.Lakeview Residency — names as they arrived, worked example#Raw NameTrimmedLength After BK-212 BK-207 bk-205 BK-209 BK-201 What is happening here• TRIM removes spaces at the start and end, and squeezes runs of spaces inside down to one. It does not touch anything else.• You cannot see the problem by looking — a trailing space is invisible. LEN is how you prove it is there.• This is why a lookup fails on data that looks correct: "BK-212 " and "BK-212" are two different values to Excel.• CLEAN is TRIM’s partner — it strips non-printing characters that arrive from copied web pages and exported systems.Lakeview Residency — imported namesSolve the following with the help of the TRIM formula.CleanedQuestionYour AnswerFill Cleaned using TRIM, then copy it down.→ fill in the tableFill Length After — how many characters remain once it is trimmed?How long is row 1 BEFORE trimming? Compare it with your Length After.Type your formula in the shaded cells. Check yourself on the Answer Key sheet. bk-203 BK-204 BK-202 bk-208 BK-210 Lakeview Residency — matching checkFrom System AFrom System BSame?BK-212Fill Same? by comparing the two columns directly. Do they match?BK-207Now compare them again with System A trimmed first. What changes?bk-205Try every question before you read this. Compare the formula, not only the result.SheetFormula to useAnswer=TRIM(C4)=LEN(TRIM(C4)) ← LEN proves the spaces are gone=LEN(C4) ← the difference is the invisible spaces=IF(C4=D4,"Match","Different") ← they look identical on screenDifferent=IF(TRIM(C4)=D4,"Match","Different") ← this is the fix for a lookup that will not matchMatchPK !q@= = [Content_Types].xmlPK !