Word Code Builder

Update the output cells so that each item displays a code built from the three words in columns C, D and E of the same row. For each item: (1) take the 2nd and 3rd characters from Word 1, (2) take the 1st and 2nd characters from Word 2, (3) take the 3rd and 4th characters from Word 3, (4) join the three segments in that order using a single hyphen "-" between each. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50