Microsoft Excel Blog: Manipulating and massaging data in Excel

The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel product group and occasional guest contributors.

Manipulating and Massaging Data in Excel

Summary:    Shows how to use Excel as a "middle man" between applications to transform address data with various functions and features to clean data, such as handling leading zeros, fixing dates, removing unwanted characters, and changing case.

Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!