Skip to Main Content
Excel Macros For Dummies, 3rd Edition
book

Excel Macros For Dummies, 3rd Edition

by Dick Kusleika
March 2022
Beginner content levelBeginner
304 pages
6h 19m
English
For Dummies
Content preview from Excel Macros For Dummies, 3rd Edition

Chapter 7

Manipulating Data with Macros

IN THIS CHAPTER

Bullet Copying and pasting a range and converting formulas in a range

Bullet Performing text to columns on all columns

Bullet Converting trailing minus signs and padding cells with zeros

Bullet Truncating postal codes to the left five

Bullet Appending text to the left or right of your cells

Bullet Cleaning up data including duplicates, extra cell space, and blank cells

Bullet Selectively hiding AutoFilter dropdowns

Bullet 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Macros For Dummies

Excel Macros For Dummies

Michael Alexander

Publisher Resources

ISBN: 9781119844433Purchase Link