importing text file

  1. K

    Removing dashes when importing text

    First time poster, long time lurker. I'm importing data from a text file, but every now and then there is a "----" in the middle of my data which creates an extra column. This throws off the rest of my formulas. Any suggestions??
  2. D

    copy text file data to a specific excel sheet via vba

    hi, i m making a utility and want to give import and export data facility. i have made code for export but for coding import data i am in trouble. while exporting data from excel to txt user can use any name or destination of file so it will not defined. can you help me to give a vba code that...
    • dgehlod
    • Thread
    • importing text file text to excel txt to excel
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top