Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2013, 10:00 AM
Pedgonc Pedgonc is offline Importing selected lines from a txt file Windows XP Importing selected lines from a txt file Office 2007
Novice
Importing selected lines from a txt file
 
Join Date: Jan 2013
Posts: 2
Pedgonc is on a distinguished road
Default Importing selected lines from a txt file

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.
Reply With Quote
  #2  
Old 01-09-2013, 08:18 AM
OTPM OTPM is offline Importing selected lines from a txt file Windows 7 32bit Importing selected lines from a txt file Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Have a look at this link:
http://www.mrexcel.com/forum/excel-q...-criteria.html
Good luck.
Tony
Reply With Quote
  #3  
Old 01-09-2013, 12:44 PM
Pedgonc Pedgonc is offline Importing selected lines from a txt file Windows XP Importing selected lines from a txt file Office 2007
Novice
Importing selected lines from a txt file
 
Join Date: Jan 2013
Posts: 2
Pedgonc is on a distinguished road
Default Thanks.

Thank you, very much.
Reply With Quote
Reply

Tags
import, txt

Thread Tools
Display Modes


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 selected lines from a txt file Importing a .pst file, with a password? Huh? MattReal Outlook 1 01-06-2011 08:03 AM
Importing selected lines from a txt file 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft