Chapter 5 Cleaning up text ・ MISSION 21
Mission 21: Join department and number into an employee code
Task
In C2:C5, show employee codes like “SLS-007”, with the number padded to 3 digits.
C2fx
A
B
C
1
Dept
Number
Employee code
2
SLS
7
3
ADM
12
4
DEV
3
5
SLS
125
6
Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.
Chapter 5 ・ MISSION 21
Join department and number into an employee code
In C2:C5, show employee codes like “SLS-007”, with the number padded to 3 digits.
A
B
C
1
Dept
Number
Employee code
2
SLS
7
3
ADM
12
4
DEV
3
5
SLS
125
6
A
B
C
1
Dept
Number
Employee code
2
SLS
7
SLS-007
3
ADM
12
ADM-012
4
DEV
3
DEV-003
5
SLS
125
SLS-125
6
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: =A2&"-"&TEXT(B2,"000")
& joins text. TEXT(number,"000") returns text with missing digits filled with 0.
To practice one function at a time:Function drillExcel function list
* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.
* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).