Microsoft Office Tutorials and References
In Depth Information
Figure 16-4: This range contains data imported directly from a CSV file.
Copying and pasting data
If all else fails, you can try standard copy and paste techniques. If you can copy data from an application (for
example, a word processing program or a document displayed in a PDF viewer), chances are good that you can
paste it into an Excel workbook. For best results, try pasting using the Home ⇒ Clipboard ⇒ Paste ⇒ Paste Special
command and try various paste options listed. Usually, pasted data will require some clean up.
Data Clean-up Techniques
This section discusses a variety of techniques that you can use to clean up data in a worksheet.
Chapter 5 contains additional examples of text-related formulas that may be helpful
when cleaning data.
Removing duplicate rows
If data is compiled from multiple sources, it may contain duplicate rows. Most of the time, you want to elimin-
ate the duplicates. In the past, removing duplicate data was essentially a manual task, although it could be auto-