Microsoft Excel’s new import functions make handling numbers easier

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it easier to refresh and reuse frequently updated data inside a worksheet. The ...

How to change Encoding in Excel, Word or Outlook

Ever opened a file or email and seen strange symbols or jumbled text? This post shows how to change the encoding in Excel, ...
Ars Technica

Excel: Importing multiple text files with same fixed-width column settings

I've got a bunch of 50MB text files (that I have to segment because of Excel's 65k limit), which I want to import into Excel and convert their data in to columns. All of the files have the same format ...