Learn
Macro 54: Create a Super Data Cleanup Macro As we mentioned at the beginning of this Part, you can combine the macros we have covered thus far ...
Macro 53: Append Text to the Left or Right of Your Cells Every so often, you may come upon a situation where you need to attach data to the ...
Macro 52: Replace Blanks Cells with a Value In some analyses, blank cells can cause of all kinds of trouble. They can cause sorting issues, they ...
Macro 51: Padding Cells with Zeros Many systems require unique identifiers (such as customer number, order number, or product num- ber) to ...
Macro 50: Truncate ZIP Codes to the Left Five U.S. ZIP codes come in either 5 or 10 digits. Some systems output a 10-digit ZIP code, which, for ...
Macro 49: Trim Spaces from All Cells in a Range A frequent problem when you import dates from other sources is leading or trailing spaces. That ...
Macro 48: Convert Trailing Minus Signs Legacy and mainframe systems are notorious for outputting trailing minus signs. In other words, instead ...
Macro 47: Perform the Text to Columns Command on All Columns When you import data from other sources, you may sometimes wind up with cells where ...
Macro 46: Convert All Formulas in a Range to Values In some situations, you may want to apply formulas in a certain workbook, but you don't ...
Macro 45: Copy and Paste a Range One of the basic data manipulation skills you'll need to learn is copying and pasting a range of data. It's ...
