Importing from text file into Excel

[rado2018]

Hello there,

Not sure if this is possible using Excel. I am trying to export specific entries from text files into Excel. However, having really hard time to do it. The text files are not formatted so it is not working for me so far. I tried the option for Data and import from file , but it just not sure where I can specify the columns that I would like to import to in Excel file. All it gives me is the one column with all the text in there ( it has 10 or so raws) , I just need 2 raws from text to go to specific Excel column.

Again I am not even sure if this is possible in Excel. Thank you for any help.

 

[VBA Geek]

When using "Import From Text" feature you have the option to skip certain columns

Check out:
https://support.office.com/en-us/article/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857