Text File to Excel Worksheet

[justlearning4]

Hello,

I have searched through the existing threads that pertain to things like this and so far, I have not been able to find a solution. I have this text file that I need to get specific data from and load it into excel; the first line of each data chunk is the part that I am looking for specifically. Ideally, I would like to then space this data out into separate columns based on the "space" delimiter that is between each word/number/date/character. Additionally, I would like this to be repeatable since this is a project that will occur on a weekly basis.

For reference, I have attached a picture of the file.

For reference, this is what I would like the first lines of each data chunk to look like once it's brought into excel.

CITY AND COUNTY OF REGION, MEXICO	11/06	1,000,000.00	Aaa3/AA-/AA-/NR
New Caldwell State	11/04	1,000,000.00	Aaa/AAA/AAA/NR

 

[rlv01]

Just a comment - when you post a graphic image of your data, it is not accessible to others and the number of people willing to manually type in your data to experiment to help you will be limited. Consider using this free tool instead to post some sample data.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com