Build a label

Intermediate← PreviousSkip →
Exercise 9 of 11 Premium

For row 5, build a label like AW-2024-1120 - Sofia Martinez: the order code, a space, a dash, a space, then the clean name.

Checking your plan…

customer-export.xlsx

ABCD
1Full nameEmailPhoneOrder code
2
3
4
5
6
7
8

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 →