+ Reply to Thread
Results 1 to 2 of 2

How to import only the selected part of data from a .txt file in Ms Excel?

  1. #1
    Registered User
    Join Date
    09-30-2015
    Location
    delhi
    MS-Off Ver
    MS Office 2010
    Posts
    4

    How to import only the selected part of data from a .txt file in Ms Excel?

    Friends i have a .txt file which contains many columns of data and i want to import only the selected part of data from that .txt file. Is it possible to do that. Normally i first go in data tab in excel then i click on from text button to import the data of .txt file, but this imports all data of .txt file. On the other hand i want only the selected part of data to be imported in excel sheet. please help me in this regard. thanks a lot.

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: How to import only the selected part of data from a .txt file in Ms Excel?

    Something like this,
    Change the file path to yours. Then with the split, extract the data that you need.
    Please Login or Register  to view this content.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] MACRO: Store name of selected file as string w/ import data file dialog box
    By AnnieMcken in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2013, 02:13 PM
  2. Trying to import selected data from SQL to Excel
    By bholabhala in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2013, 12:06 PM
  3. Need help to import selected data to excel
    By matthewsappo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2013, 02:51 AM
  4. Import data from selected excel file into a specified worksheet
    By Shogun in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-15-2012, 10:45 AM
  5. Macro to import selected data from a master data file
    By HalaK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2010, 09:14 AM
  6. import data from .txt file selected by user
    By ahartman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-29-2008, 03:34 AM
  7. Excel should be able to import selected data from MS Word
    By family1935 in forum Excel General
    Replies: 0
    Last Post: 02-13-2006, 04:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1