Replace characters

Intermediate← PreviousSkip →
Exercise 8 of 11 Premium

Reformat the phone number in C3 from 555.388.1902 to 555-388-1902.

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 →