How would I convert the following into a excel sheet?

P

Phillips

I thought I posted this yesterday, but I could not find it... Sorry of a
repost if it is here...

I get info from a website, and I would like to cut and paste it into a
worksheet.
The info comes like the following:

Monday November 24th
1:30 PM CST - Subject
Instructor Name




8:30 PM CST - Subject
Instructor Name


Tuesday November 25th

1:30 PM CST - Subject
Instructor Name

2:30 PM CST - Subject
Instructor Name

8:30 PM CST - Subject
Instructor Name

Wednesday November 26th
1:30 PM CST - Subject
Instructor Name

8:30 PM CST - Subject
Instructor Name

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

What I would like to do is have it formatted as:
Date Time (or date and time) Class Instructor

Several issues that I have not been able to figure out, but the main
one is how to take the date (no year, but has text day of week and month)
and convert this into a valid date.

Thanks
Phil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identifying the entity ... 3
OL2013: Goofy sorting order for e-mails within a conversation 1
Pivot Table Creation Macro fails with Error #5 "Invalid procedure call or argument" 1
Creating automated timesheets 2
Putting a formula in place one time for the entire spreadsheet 2
In EXCEL, how do I make date-time the x-axis of a plot?????? 1
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Problems with Custom Sub to Import to User-Defined Fields 3

Top