Importing selected lines from a txt file

Pedgonc · #1 01-08-2013, 10:00 AM

How can I select which lines to import from a txt file?

For example:
txt file
A;1;100;100
A;2;150;200
B;1;200;300
A;3;010;020

C;1;500;100

I need to import lines starting with "A" to a worksheet named "A", lines starting with "B" to a worksheet named "B" and so on.

Anybody can help me?

Thank you.

OTPM · #2 01-09-2013, 08:18 AM

Hi
Have a look at this link:
http://www.mrexcel.com/forum/excel-q...-criteria.html
Good luck.
Tony

Pedgonc · #3 01-09-2013, 12:44 PM

Thank you, very much.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing Selected Text Into Word Document	Mooseman60	Word	1	10-06-2011 03:18 AM
Importing a .pst file, with a password? Huh?	MattReal	Outlook	1	01-06-2011 08:03 AM
Importing a PST file	Swoosh983	Outlook	1	08-20-2010 01:31 AM
Importing .pst and backup csv file	shirlthepirl	Outlook	0	09-04-2009 09:35 AM
Importing .pst file - error	Mustang	Outlook	0	02-23-2006 07:35 AM