Chapter 7
Manipulating Data with Macros
IN THIS CHAPTER
Copying and pasting a range and converting formulas in a range
Performing text to columns on all columns
Converting trailing minus signs and padding cells with zeros
Truncating postal codes to the left five
Appending text to the left or right of your cells
Cleaning up data including duplicates, extra cell space, and blank cells
Selectively hiding AutoFilter dropdowns
Copying filtered rows and showing filtered columns in status bar
When working with information in Excel, you often have to transform the data in some way. Transforming it generally means cleaning, standardizing, or shaping data in ways that are appropriate for your ...
Get Excel Macros For Dummies, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
