con·cat·e·nate | a scary looking word created to make life simple. Simply, string concatenation joins two character strings together. OK, realistically simple example, if your excel database contains an address separated by columns and you’d like to mass mail each address without physically retyping the addresses into a single column, the excel tool concatenate will combine the columns for you. Ta Dah! …
The “other” IF Statements
In the past, we taught you how to become an Excel Bully, and while we don’t really condone stealing other kids’ lunch money, we do believe it’s an important first step. So if you haven’t yet read the beginner’s guide to Excel if statements, click here! Excel has supplied us with a few close cousins to the IF statement, …