how to extract data from notepad to excel using macro?
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. ;-)