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
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.