Today’s author is Jan Karel Pieterse, an Excel MVP, who describes the process of importing text in great detail. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ . In this article, I'll explain how to ease importing of .txt, .prn and/or .csv files into an existing sheet in Excel. Introduction If you've ever tried to open a text file, you have probably used the Text import wizard. If you have ever opened a CSV file, you have probably noted you can't
Read More...
Read the complete post at http://blogs.msdn.com/b/excel/archive/2010/06/11/importing-text-files-in-an-excel-sheet.aspx
Posted
Jun 10 2010, 08:25 PM
by
Microsoft Excel 2010