import selected lines from a text file

**harkirat777** · 10-24-2013, 11:18 AM

Hi

I want to import say lines 10,12,13,14,25,26,27,28 from a text file of total 300 lines to excel, with split delimiter being :
Also I want to ignore the spaces.
Can anyone help me please.
Thanks in advance.

**ragulduy** · 10-24-2013, 11:41 AM

Maybe something like below? I'm not sure what you mean about split delimiter, maybe use text to columns after importing the data?

Please Login or Register  to view this content.

**excelVBAmaster.com** · 10-24-2013, 11:51 AM

You can read the text file like this:

Please Login or Register  to view this content.

**Norie** · 10-24-2013, 11:56 AM

Is : a line delimiter or field delimiter?

import selected lines from a text file

LinkBack

Thread Tools

Rate This Thread

Display

import selected lines from a text file

Re: import selected lines from a text file

Re: import selected lines from a text file

Re: import selected lines from a text file

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] MACRO: Store name of selected file as string w/ import data file dialog box

[SOLVED] Import user selected columns from a text file

Import text with new lines

Import Certain Lines from a Large Text File

Import Text File Into A Spreadsheet with over 65,000 lines

Bookmarks

Bookmarks

Posting Permissions