View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default copy from multicolumn .txt document

You can either change the extension to .csv and Excel should open it
normally.
Or in Excel, go FileOpen and follow the steps.
Either way, you can then copy and work the data in Excel.

NickHK

"rea" wrote in message
oups.com...
can somebody help me...
i have a .txt wich holds data in 5 or six colums separated with sign
",".
i manage to copy data from .txt wich holds only one column, but i dont
know how to solve this problem.i need to copy only 1 column from .txt
(lets say third) to .xls .
the number of rows is huge.