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

Excel automatically recognizes common formats, such as "3/17/2012," "Mar 17, 2012" or "17 Mar 2012." Use the Month function to extract the month number from a referenced cell.