Excel Power Utility Pak

I first found out about John Walkenback from his books. He, without question, has the best books on Excel. Back when books only were made from dead trees I judged books by how much real information versus fluff. He wins outright. His books now are available in paper...

Hyphen Minus Dash

I was working in Excel matching some strings and they were not matching even though they looked the same on the screen. Well it turns out that there are different kinds of dashes! A normal dash you use is the keyboard is the minus sign on your keyboard. But there are...

Excel Parser

I had written my own but it had a bug. Then I found this code below on this site. It gives credit to John Walkenbach who writes, bar none, the best books on Excel. Public Function ExtractElement(Txt, n, Separator) As String ‘ Returns the nth element of a text...

Excel XOR

Excel 2010 doesn’t have an XOR function. The newer versions do. I have needed this form of logic a couple of times recently and I found a good tip here. XOR works like this. A B Result 1 1 0 1 0 1 0 1 1 0 0 0 So, if you don’t have an XOR function you can...

Trim Function

This is to remove excess characters from a string. It can be enhanced with options or changed depending if you want spaces or not etc. Function fixchar(s As Variant) As Variant Dim a, b, i As Integer fixchar = “” If Len(s) = 0 Then Exit Function For i = 1...

Excel Conditional Formatting

I’m always forgetting the syntax and also here’s some tricks. How to highlight cells based on another cell’s value in Excel 2011 – Ask Different Format cell color based on value in another sheet and cell – Stack Overflow Conditional...