Bledsoe encountered that problem when she had to extract data from Lotus 1-2-3 — a now-obsolete commercial spreadsheet program. “Trying to finagle that data added a whole other step,” she says.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.