by Nate Moore | May 4, 2011 | Functions
Excel Video 154 is short and easy. I’ll introduce two functions, FIND and LEN. FIND looks for a text string inside another text string. I use FIND to look for text inside a cell, and the most common thing I look for is a comma that separates a last name from a first...
by Nate Moore | May 2, 2011 | Functions
Excel Video 153 might be EXACTly what you need to make your life easier. EXACT is a simple Excel function that compares two text strings (say the text in two different cells) to see if they’re exactly the same. Today’s trick is to combine EXACT with CONCATENATE from...
by Nate Moore | Apr 27, 2011 | Functions
Excel Video 152 describes two ways to concatenate functions in Excel. Even if concatenate didn’t have my name in it, it would still be a handy function. Concatenate means to put something on the end of something else, or to stuff things together. You’ll find it handy...
by Nate Moore | Apr 25, 2011 | Functions
Excel Video 151 explains how to use IFERROR to replace all of Excel’s error messages with something more appropriate. IFERROR is a simple Excel function that takes a formula and evaluates it. If the formula works, fine. Excel will show you the result of the formula....
by Nate Moore | Apr 20, 2011 | Functions
When you’re done with Excel Video 150, you might be thinking that NOT is a lot like the devil, always telling you bad is good and good is bad. The NOT function simply takes something that’s true and returns false, or something that’s false and returns true. It’s hard...
by Nate Moore | Apr 18, 2011 | Functions
Excel Video 149 continues our discussion of logical functions by introducing OR. In Excel Video 148, all of the conditions had to be true to make the statement true. This time, only one of the conditions needs to be true to make the statement true. The IF statement in...
