Hey everyone,
I’d like some help to create a marco that will import a txt file containing up to 100 lines into excel and sort it into columns. I’m ashamed to say that I’ve been doing it manually as I’ve never had the time to learn how to use excel properly until now.
I’m a slow learner but I’m determined to learn how use excel as it could really help me at work.
Thanks for any help

this is the format of the txt source file:

"Jonnyenglish___________X"
Optimized meds: 9 units: (34.0006% sin) 22.3611: Meda, Medabc, demB#2, Meda, Medabc, demab
"JonnyBrovo___________X"
Optimized meds: 5 units: (60.106% sin) 5: Meda, Medabc, dema, Meda, Medabc, demab
"JonnyDepp___________X"
Optimized meds: 9 units: (17.6% sin) 90.11: Meda, Medabc, htctttt, Meda, Medabc, demab
"JonnyKnoxville_________X"
Optimized meds: 7 units: (34.0006% sin) 31.3322: Dpata#3, Medabc, dema, Meda, Medabc, demab

This is how I would like it to be sorted:
Jonnyenglish___________X 9 units 34.0006% sin 22.3611 Meda, Medabc, demB#2, Meda, Medabc, demab
JonnyBrovo_____________X 5 units 60.106% sin 5 Meda, Medabc, dema, Meda, Medabc, demab
JonnyDepp______________X 9 units 17.6% sin 90.11 Meda, Medabc, htctttt, Meda, Medabc, demab
JonnyKnoxville_________X 7 units 34.0006% sin 31.3322 Dpata#3,Medabc,dema,Meda,Medabc,demab