Clean imported data with PROPER and TRIM
BeginnerImported data often arrives in rough shape. Names may use inconsistent capitalization, and notes copied from another system often contain extra spaces that make the text look sloppy and harder to reuse.
In this exercise, you'll practice a simple imported data cleanup workflow. Use PROPER to standardize customer names and TRIM to remove leading, trailing, and repeated spaces from notes.
How these functions work:
=PROPER(text)
Use PROPER to convert text to standard title case.
=TRIM(text)
Use TRIM to remove extra spaces from text while keeping single spaces between words.
What you need to do
Fill cells B2:B11 and D2:D11 so the cleaned columns show properly capitalized names and notes with tidy spacing.
- In cell B2, enter a PROPER formula that references the original customer name in A2.
- In cell D2, enter a TRIM formula that references the imported note in C2.
- Fill both formulas down through row 11 so each row completes the same cleanup workflow for the matching name and note.
Need some help?
Hint 1
PROPER fixes capitalization by making each word start with a capital letter, while TRIM removes extra spaces from text. Both functions use one text cell as their only argument.
Hint 2
In each row, build the cleaned name in column B from the original name in column A and the cleaned note in column D from the original note in column C, then fill both formulas down through the rest of the table.
Related function(s)
Clean imported data with PROPER and TRIM
BeginnerImported data often arrives in rough shape. Names may use inconsistent capitalization, and notes copied from another system often contain extra spaces that make the text look sloppy and harder to reuse.
In this exercise, you'll practice a simple imported data cleanup workflow. Use PROPER to standardize customer names and TRIM to remove leading, trailing, and repeated spaces from notes.
How these functions work:
=PROPER(text)
Use PROPER to convert text to standard title case.
=TRIM(text)
Use TRIM to remove extra spaces from text while keeping single spaces between words.
What you need to do
Fill cells B2:B11 and D2:D11 so the cleaned columns show properly capitalized names and notes with tidy spacing.
- In cell B2, enter a PROPER formula that references the original customer name in A2.
- In cell D2, enter a TRIM formula that references the imported note in C2.
- Fill both formulas down through row 11 so each row completes the same cleanup workflow for the matching name and note.
Need some help?
Hint 1
PROPER fixes capitalization by making each word start with a capital letter, while TRIM removes extra spaces from text. Both functions use one text cell as their only argument.
Hint 2
In each row, build the cleaned name in column B from the original name in column A and the cleaned note in column D from the original note in column C, then fill both formulas down through the rest of the table.