Clean up a name

IntermediateSkip →
Exercise 1 of 11TRIMPROPER

Clean the name in A2: remove the extra spaces and capitalize it properly.

Write your formula in the green cell, G2.

Text

Clean up a nameStore codeText from the endCount charactersPull out the yearEmail domainText before a characterReplace charactersBuild a labelFirst name from a messy cellJoin a list
customer-export.xlsx
fx
1Full nameEmailPhoneOrder code
2 emma JOHNSON [email protected](555) 201-4433NW-2026-0187Clean name
3liam o'brien[email protected]555.388.1902CT-2025-0942
4OLIVIA chen [email protected]555-647-2210FB-2026-0033
5noah patel[email protected](555) 903 7751NW-2026-0451
6Sofia Martinez[email protected]555 412 0098AW-2024-1120
7
8
9
10

Click a cell to add it to your formula, drag to select a range, or click a column letter for the whole column.

About text in Excel

Real data is messy. These exercises use an exported customer list with extra spaces and random capitals. You'll clean names with TRIM and PROPER, pull pieces out of codes with LEFT and MID, and join text together.

Functions you can use here

  • TRIM(text)
  • PROPER(text)
  • LEFT(text, [num_chars])
  • MID(text, start_num, num_chars)
  • TEXTAFTER(text, delimiter, [instance_num])

More text exercises

  1. 1.Clean up a name
  2. 2.Store code
  3. 3.Text from the endPremium
  4. 4.Count charactersPremium
  5. 5.Pull out the yearPremium
  6. 6.Email domainPremium
  7. 7.Text before a characterPremium
  8. 8.Replace charactersPremium
  9. 9.Build a labelPremium
  10. 10.First name from a messy cellPremium
  11. 11.Join a listPremium
See the whole topic →