Convert Text to Excel.

Pluto_Flying · 24th Feb 2008, 03:10 AM

Can any one help me in converting the txt file to excel as shown below.

Inputfile.txt
------------
NAME : JAMES LIMO
DATE : 12/10/2007
UNIT : CHICAGO
SUB-UNITS : TTK
HHK
LKT

NAME : DAVID SHEFIELD
DATE : 10/03/2007
UNIT : MEXICO
SUB-UNIT : HJO
BTR
GTS
PKL
MPCI

NAME : KIN MIN CHONG
DATE : 03/04/2005
UNIT : DENVOR
SUB-UNIT : HHK
PKL

*******************************************

Outputfile.xls
-------------
NAME DATE UNIT SUB-UNITS

JAMES LIMO 12/10/07 CHICAGO TTK HHK LKT
DAVID SHEFIELD 10/3/07 MEXICO HJO BTR GTS PKL MPCI
KIN MIN CHONG 3/4/2005 DENVOR HHK PKL

Adrian Wong · 24th Feb 2008, 03:42 AM

Well, you should separate the values by commas and import as .CSV files.

zy · 25th Feb 2008, 03:34 AM

cant think of an easy way ...

maybe you can delete the "Name : "
replace "Date : ", "Unit : ", etc with tab.
and put all info into the same line & open it in excel.

Chai · 25th Feb 2008, 07:58 AM

I think he doesn't have MS Excel, and wants us to do it for him.

24th Feb 2008, 03:42 AM	#2 (permalink)
Adrian Wong Da Boss Join Date: 10 Oct 2002 Location: In front of my ASUS F8V notebook! Posts: 32,299 Reputation: 3574 Rep Power: 75	Well, you should separate the values by commas and import as .CSV files. __________________ Dr. Adrian Wong Tech ARP \| Blog @ Tech ARP \| The Free Trade Zone DYKT : The only offshore account I have is at the sand bank? We need PROGRAMMERS and TECHNICAL WRITERS! Contact us if you are a hot shot programmer or technical writer! My items for sale : 50x SD Card \| Memory Stick PRO \| Cyclone Energy Saver \| Seiko SS watch \| Tiger/Carlsberg beer jugs \| Travel Speakers \| Motorola V600 \| Nokia N90 SOLD! \| New Lowepro Mini Trekker AW Other items for sale @ the FTZ : Zalman CNPS9500 LED @ $20 \| Zalman CNPS7700 Cu @ $20 \| Zalman CNPS7000 Cu @ $20 \| Swarovski bracelet watches \| Dell 17" LCD \| Hi-Fi speakers \| English DIVX movies \| HP LaserJet toners! \| Office chairs

25th Feb 2008, 03:34 AM	#3 (permalink)
zy Dead Join Date: 16 Dec 2002 Location: Buffalo NY / Penang MY Posts: 13,336 Reputation: 2158 Rep Power: 41	cant think of an easy way ... maybe you can delete the "Name : " replace "Date : ", "Unit : ", etc with tab. and put all info into the same line & open it in excel. __________________

25th Feb 2008, 07:58 AM	#4 (permalink)
Chai Administrator Join Date: 6 Oct 2002 Location: Maranello Posts: 27,884 Reputation: 4630 Rep Power: 81	I think he doesn't have MS Excel, and wants us to do it for him. __________________ Chai (Contributor & Forum Admin) http://www.techarp.com/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Audio/video converter. Convert to MP3, AAC, WAV, MPEG4, DivX etc. YouTube ripper	Midia	General Software	4	27th Oct 2008 05:17 PM
anyone know how to convert text file into excel file?	miracleplasma	General Software	7	18th Jun 2004 10:01 PM