Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing data from text file
Hi, I have the data in the following format in the .txt file. A-0010 ZZXXXX (here ZZXXXX is some description which is seprated from the code A-0010 by some space.The code "A-0010" ends in a digit) X:XXsome description (I need to put information only after ":" under Column3) Y:YYsome description (I need to put information only after ":" under Column4) I need to put the above data in the following format in excel sheet :- Column1 Column2 Column3 Column4 A-0010 ZZXXXX XXsome description YYsome description Can you please help me out with this? Thanks Tushar Johri -- tushar_johri ------------------------------------------------------------------------ tushar_johri's Profile: http://www.excelforum.com/member.php...o&userid=30181 View this thread: http://www.excelforum.com/showthread...hreadid=498629 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Text File with Comma Seperated Data - Need Help Pls | Excel Discussion (Misc queries) | |||
importing text file data into excel | Excel Discussion (Misc queries) | |||
character restrictions when importing data from a text file | Excel Discussion (Misc queries) | |||
Importing data from a Text File, Not enough lines? | Excel Programming | |||
importing text file, removing data and outputting new text file | Excel Programming |