FormulaCamp
Completed
4. Excel Functions · Text · 15 min

16. Text: & and UPPER

Lesson 16 of 25
Task 1 of 2
  1. In C2:C5, build "First Last" with a space between the names.

Lesson theory

The & sign joins text: =B2&" "&A2 gives "Adam Parker". You have to add the space yourself, in quotation marks.

=UPPER(A2) makes all letters capitals, and =LOWER() makes them lowercase.

Practice is part of Pro

The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.