ABCDEF
1
=concatenate(textstring1, textstring2,textstring3…)
2
3
4
Employee First NameEmployee Last NameFull Name
5
JohnSmith
6
RoseMary
7
TomHanks
8
KimWilson
9
MichelleWilson
10
JoyceLu
11
AlicePfeiffer
12
MelissaFong
13
JessicaAlba
14
CarrieGravelle
15
HalleBerry
16
TimFu
17
18
19
20