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
25
And any duplicates will be highlighted:
To delete duplicate values, select the area where duplicates are to be deleted,
use the Remove Duplicates tool under the Data tab:
Once applied, a pop-up
window will let you know
how many duplicates were
removed and how many
unique values remain:
CONCATENATING CELLS
Sometimes, information has been parsed out into separate cells in Excel and
it's necessary to string the values back into a single cell. A simple example
could be a list of names and surnames in separate fields, while the goal is to
have them appear in a single cell, in a certain manner.
In the example below, the goal is for column C to reflect the surname
(Column B) followed by the first name (Column A):
To use the Concatenate function, place the cursor in cell C1 and begin entering
=concatenate and double-click on the symbol when it appears:
Select the cells in the order you would like the information to appear,
separated by a comma, and add a closing parenthesis:
