I
L
T
A
W
H
I
T
E
P
A
P
E
R
|
L
I
T
I
G
A
T
I
O
N
A
N
D
P
R
A
C
T
I
C
E
S
U
P
P
O
R
T
26
which will give the following result:
This may not exactly be what you are looking to achieve. To add a comma and
a space automatically between the surname and name, make the following
change to the formula to separate the surname and the name by a comma
and a space:
=CONCATENATE(B1&", ",A1)
which will return the desired results:
Once the result is satisfactory, use the Fill Cell Handle to copy the formula
down to the end of the list by double-clicking on it or dragging it down to the
last row:
This simple example can be
adapted to your needs in much
more complex situations.
