Tag Archives: data import

Cleaning up data imported into Microsoft Excel

Many MS Excel users find that they have to work with data originating in other applications, such as database, payroll and accountancy, websites and content management systems. Often problems arise when the data is inserted into MS Excel, resulting in difficulties working with the new spreadsheet. One solution I’ve found extremely useful is to ‘clean’… Read More »