Count characters

Intermediate← PreviousSkip →
Exercise 4 of 11 Premium

How many characters are in the phone number in C5, including spaces and brackets?

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 →