Course contents · Problem book

Working with text

Open the practice in the trainer →

Text functions build and take apart strings:

LEFT / RIGHTfirst / last characters
MIDcharacters from the middle
LENlength of a string
UPPER / LOWERletter case
&joining: =A2&" "&B2

Tasks in the trainer

  1. In C2:C6 build a form like “Austen J.”.
  2. In D2:D6 count the letters in the surname.
  3. In E2:E6 write the surname in capital letters.
  4. In F2:F6 return the last letter of the surname.
  5. In I1 count the surnames longer than 6 letters.

Solve the tasks in the trainer →