Tag Archives: Microsoft

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

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

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