Part V: Working with Data
This Part is all about managing data: cleaning it up, formatting it, and more.
In This Part
Macro 45 Copy and Paste a Range
Macro 46 Convert All Formulas in a Range to Values
Macro 47 Perform the Text to Columns Command on All Columns
Macro 48 Convert Trailing Minus Signs
Macro 49 Trim Spaces from All Cells in a Range
Macro 50 Truncate ZIP Codes to the Left Five
Macro 51 Padding Cells with Zeros
Macro 52 Replace Blanks Cells with a Value
Macro 53 Append Text to the Left or Right of Your Cells
Macro 54 Create a Super Data Cleanup Macro
Macro 55 Clean Up Non-Printing Characters
Macro 56 Highlight Duplicates in a Range of Data
Macro 57 Hide All Rows but Those Containing Duplicate Data
Macro 58 Selectively Hide AutoFilter Drop-down Arrows
Macro 59 Copy Filtered Rows to a New Workbook
Get 101 Ready-To-Use Excel Macros 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.