I'm working with a Word Document that includes course number, course title and course description. I saved the document as a .txt file and used Excel to open the .txt file.



The current Excel format is one column; one row contains course number and title and the row directly below contains course description. My goal is to add 3 additional columns to include course number, course title, and course description. Course description needs to included the information from Col B and insert description into column E. In the example below B1 data should appear in C1 and D1; B2 should appear in E1 without (Course Credits).

Is this possible? Please see attachment for example.

Thank you for your assistance

Attached Files

Sample Data.xlsx (8.8 KB, 13 views)

Can you upload of a copy of how it is displaying when you open the TXT in Excel so I can see what you mean?