Excel Macros
Revision as of 10:21, 12 March 2008 by imported>Bob
Handy Code Snippets
This page contains links to several Excel Macros that Bob's made. Feel free to use or add additional ones.
- Save Macros in Excel-- a brief How-To
- Julian to regular date converter
- Regular Date to Julian Converter
- Calculate Daily Averages / Sums from hourly data
- Freezing / Thawing Indices
- Cell Wrap -- Useful for long column headers in data spreadsheets.
- Data Split -- Short Macro for splitting comma & tab separated data such as when you open a .txt file in Excel