Converting a string date into a Excel Date
 

I have a website I need to import data from.

It has the date listed like "Tuesday November 25th" and then below it, the
time, class and then the instructor

I would like to have it import the data and then have it like
Date Time (or date and time as one field) Class Instructor.

How can I do this?

There might be different classes per day, and some days, no classes.

Here is a sample of this weeks schedule.

Thanks
Phil




Monday November 24th
1:30 PM CST - Training Call
First_Name lastName

8:30 PM CST - New Rep Training
First_Name lastName


Tuesday November 25th

1:30 PM CST - New Rep Training
First_Name lastName

2:30 PM CST - Team Calls
First_Name lastName

8:30 PM CST - Training Call
First_Name lastName

Wednesday November 26th
1:30 PM CST - Training Call
First_Name lastName
8:30 PM CST - New Rep Training
First_Name lastName

Thursday November 27th
No New Rep Training - Thanksgiving Day


No Team Calls - Thanksgiving Day

No Training Call - Thanksgiving Day


Friday November 28th

No New Rep Training - Thanksgiving Holiday


Saturday November 29th

No New Rep Training - Thanksgiving Holiday