Import txt file in Excel

Hi
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.

Answer

Go to the Data Menu and Import text file

Importing text file into excel sheet

(for formulas, depending on your country, you might have to change ; with , or the opposite

Other excel answers

 

 

You can find similar Excel Questions and Answer hereunder

1) Is there a way I can recover unsaved work?

2) How to read a value from a cell in vba in Excel

3) Userform initialize vs userform show in Excel

4) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?

5) How can I add a WorkSheet and name it as required using VBA?

6) How can I avoid updates to cell values during macro execution?

7) How can I copy and rename a WorkSheet using VBA?

8) How can I sort data using VBA?

9) How can I export a chart as a gif file?

10) How can I loop through all ActiveX checkboxes in WorkSheet and set them to Unchecked status?

11) How can I dynamically add series to an existing chart using VBA?

12) How can I change the Marker size and Marker line color for all the series in a chart?

13) How can I extract file name from a full path including folder path and file name?

14) How can I update a listbox based on data in a list using VBA?

15) How can I add a legend to a chart using VBA?