Import txt file in Excel
I am new to macro ad want to import a text file into excel
1. Text file = test.txt
2. Want to import text file to a certain worksheet (sheet1) start at row 0 and column A
3. All data from txt file must be imported.
Go to the Data Menu and Import text file
(for formulas, depending on your country, you might have to change ; with , or the opposite