Excel 2019 Bible

Part IV: Managing and Analyzing Data

FIGURE 25.10

Using formulas to identify duplicate rows

If the text is all the same length (as in the example), you might be able to write a series

of formulas that extract the information to separate columns. The LEFT, RIGHT, and MID

functions are useful for this task.

FIGURE 25.11

The imported data was put in one column rather than multiple columns.