What I’ve been consuming
I'm reading...The Zenith Angle - Bruce SterlingMarch 2008Random Quote
She had Lord Masham on one side of her and on the other the accomplished Mr. Mulliner, editor of the new high-class lively evening paper which was expected to meet a want felt in circles increasingly conscious that Conservatism must be made amusing, and unconvinced when assured by those of another political colour that it was already amusing enough.
- Henry JamesThe archive
Categories
Tags
ABC This Week AWS ColdFusion COM Dylan faith George F. Will home maintenance hubris Is It My Code Or Is It A Bug Java linux newbie ListQualify Meet the Press Microsoft N.T. Wright Palm PDA PHP podcasts pynchon reading Ron Coulter security Spy Sweeper Stack Overflow Technology the blog VBA Virtual PC WordPress XML XSL
Category Archives: Excel
Dumping file info into an Excel spreadsheet
So you’ve got a folder full of documents and you want to know what’s in the folder, how big the files are, and when they were last modified? And of course you want to be able to filter and sort … Continue reading
Export Microsoft Outlook Journal entries to Excel
If you’re a Microsoft Outlook Journal user, save this code into a macro to export journal entries from a select time range into Excel. Updated for Excel 2007. In your macro window, under Tools>References, make sure you check the Microsoft … Continue reading
Cool Excel formula for replacing line breaks
If you copy and paste from another application into Excel, chances are you’ll come across some boxes that create unsightly line breaks in your cells. Use this formula to make those line breaks disappear: =SUBSTITUTE(SUBSTITUTE([celladdress],CHAR(13),” “),CHAR(10),”") where [celladdress] is the … Continue reading