Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Clean up imported or pasted data in Excel

When you bring data from other sources into Excel, it may not look the way you'd like -- numbers might have come in as text so that you can't sum them, dates might not be dates at all...you get the idea. Here's how to clean things up so your spreadsheet looks and works right. ...( read more ) Read More...

Read the complete post at http://blogs.office.com/b/microsoft-excel/archive/2011/09/20/clean-up-imported-or-pasted-data-in-excel.aspx


Posted Sep 20 2011, 02:46 PM by Excel Blog
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.