If you often work with data that starts life as a text file or CSV, Microsoft Excel now has new built in tools that simplify how that information gets pulled into a spreadsheet. The update introduces two new functions, IMPORTTEXT and IMPORTCSV, designed to bring external data directly into Excel cells using formulas. Instead of going through the traditional import wizard every time, users can now load files straight into a worksheet and keep that data connected to its source. The IMPORTTEXT...
