Civil Engineering Projects
Macro 55: Clean Up Non-Printing Characters
Sometimes you have non-printing characters in your data such as line feeds, carriage returns, and
...
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 ...
Macro 44: Dynamically Set the Print Area of a Worksheet
In certain situations, you may find yourself constantly adding data to your spreadsheets. ...
