ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
LEFT, RIGHT, MID; UPPER, LOWER, PROPER; &, CONCATENATE
3
4
5
1Open 'Sheet 2'. In G2 extract the first 7 letters of the "word" written in B2.
6
7
8
2In G3, extract 10 characters contained in the "word" written in B3. Start from the 10th character.
9
10
11
3In G4, extract two characters contained in the "word" written in B4. Start from the 18th character.
12
13
14
4In G5, extract the last 4 characters of the "word" written in B5.
15
16
17
5In I2, present the proper version of the word written in G2.
18
19
20
6In I3, present the lower version of the word written in G3.
21
22
23
7In I4, replicate the word written in G4.
24
25
26
8In I5, "capitalize" the word written in G5.
27
28
29
9Use L2 to create a sentence with the words that you find in the range I2:I5 using "&".
30
31
32
10Use L2 to create a sentence with the words that you find in the range I2:I5 using CONCATENATE.
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100