March 2022
Beginner
304 pages
6h 19m
English
Chapter 7
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 ...