Split Date Ranges and Convert to Actual Dates

In this Excel tutorial I will show you how to import messy CSV data into Excel, use the Text to Columns feature to split it into separate fields, format the dates correctly, sort the data, and create a simple line chart to visualize trends. This lesson is great for beginners and focuses on practical, step-by-step techniques with no advanced formulas or programming.

Prerequisites

• Free Excel Beginner 1

Links

• Text to Columns
• ISO Date Format

Recommended Courses

• Microsoft Excel Courses

Learn More!

• FREE Excel Beginner Level 1
• Excel Beginner Level 2 for $1.00
• Excel Forum
• Mailing List Notifications for New Videos

Questions?

Please feel free to post your questions or comments below. Thanks.

Keywords

TechHelp Excel, Text to Columns, split CSV data, date formatting, month-day-year conversion, line chart creation, importing data to Excel, sorting data, ISO date format, CSV to Excel columns, water usage chart, Excel beginner tutorial, resizing columns, Excel date values, Excel TechHelp, deleting columns in Excel, Excel data cleaning, chart outliers, Excel data import, Excel line charts