Question: how to extract data from notepad to excel using macro?
Answer: Start the macro recorder, open your text file with Excel, split the lines with the import assistant, stop the macro recorder. Do the transformation with formulas. IMHO a waste of time, try by yourself how far you get. ;-)