Importing non-delimited text file into excel

I've a specific requirement where in I need to import text file which is non-delimited and contents should be copied to Excel in different columns...

Text file contents is as below.

Need VBA code to copy this in Excel different columns like

DAte and time should go to Column A
Incident status before - should go to Column B
and contents between - and new date start should go to Column C

Expected Output.jpg

If you open the text file in Excel, you can use some Helper columns to isolate the date, priority and data. Unfortunately, you will probably need to use VBA to extract the data.

First, insert a header row. Then set A1 to E1 to Text, Date, Time, Priority and Priority Text respectively

Then:

B2:

Formula:

Please Login or Register  to view this content.

C2:

Formula:

Please Login or Register  to view this content.

D2:

Formula:

Please Login or Register  to view this content.

E2:

Formula:

Please Login or Register  to view this content.

Copy the formulae down to the end of the data.

You can now filter on the priority column for "yes" to see the date, time and priority text.

As for the data in between those rows, it is very, very variable. As I said, I think you will need VBA to collate the message content into a single cell. In principle, it shouldn't be too difficult - you know the rows with message headers and you can use something like ConcatAll to concatenate the data between those row.

VBA Code is the issue for me...I'm not too familiar with VBA code....if you can help in getting the VBA code for this issue, it would be of great help....