Category Archives: Microsoft

Windows 7/Java/Oracle SQL Developer

Posted on February 8, 2011 by arcster

Just got a new Dell laptop at work running 64-bit Windows 7. Naturally, some problems are arising: Had trouble getting Oracle SQL Developer (version 1.5.5) to run. First it told me I needed to install the Java SDK. So I … Continue reading →

Posted in Java, Windows 7 | Comments Off

more cool Excel formulae

Posted on February 2, 2011 by arcster

So I have some Excel data that looks like this: Team days RB 3 RBB 6 RBC 9 RA 100 RA 114 RAX 125 and in my Sheet2 worksheet I want to show the averages of the days each team … Continue reading →

Posted in Excel, Microsoft | Tagged , | Comments Off

Dumping file info into an Excel spreadsheet

Posted on June 9, 2010 by arcster

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 →

Posted in Excel, Microsoft, Programming | Tagged | Comments Off

Export Microsoft Outlook Journal entries to Excel

Posted on May 4, 2010 by arcster

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 →

Posted in Excel, Outlook | Tagged , | Comments Off

Shun Virtual PC 2007 if you want Ubuntu

Posted on March 12, 2010 by arcster

I wish I had read the Ubuntu forum posting about Microsoft Virtual PC before wasting an hour+ of my life trying to get Ubuntu 9.10 to work on Microsoft Virtual PC 2007. Everything installed fine, but I could get the … Continue reading →

Posted in Microsoft, Ubuntu Linux | Tagged , | Comments Off

Cool Excel formula for replacing line breaks

Posted on March 8, 2010 by arcster

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 →

Posted in Excel, Microsoft | Tagged , | 1 Comment

Find and replace for fixed width text in Microsoft Word

Posted on August 12, 2009 by arcster

If you have rows of fixed-width data (in this case the first 12 characters of each row) and you want to put a tab at the end, put this in your “Find what” box in Microsoft Word: (^13*{12}) and put … Continue reading →

Posted in Microsoft, Regular Expressions | Tagged , | Comments Off

CD burning problems

Posted on April 22, 2009 by arcster

I have of late, but wherefore I know not, lost all my ability to burn CDs. Continue reading →

Posted in Microsoft, Technology | Comments Off

Another helpful innovation from Internet Explorer

Posted on March 4, 2009 by arcster

If an add-on is hosing Internet Explorer, you have to run Internet Explorer WITH ADD-ONS ENABLED in order to manage your add-ons. McAfee Site Advisor is completely hosing a friend’s Acer Aspire. I advised installing Firefox, and somehow Site Advisor … Continue reading →

Posted in Internet, Microsoft | Comments Off

Excel formula

Posted on December 12, 2008 by arcster

Let’s say cell B5 has a number between 0 and 100, where 0-33 is low, 34-66 is medium and 67-100 is high. Here’s a formula to display the appropriate text =IF(B5

Posted in Microsoft | Comments Off