Excel will automatically fill data without dashes in the remaining cells. Alternatively, you can also select the Flash Fill under the Home tab.

How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.

If you intend to obtain a list of all dates or data between two given dates in Excel, then you can Use the Fill handle or use a Formula. Learn how.

How to Fill Out Spreadsheets. Whether you're a data management expert or a businessperson needing to add up a few numbers, you can find a way to do it using a spreadsheet. The row-and-column ...

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

I have to manually add this information in order to complete the analyses required. Is there a better way to fill these blank cells? A. I have created an example spreadsheet to mimic the issue ...

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.