Change Case of Text in Excel
One question I get all the time is how to change the case of text in Excel. Some applications require case-specific text to make a match with its data. Or you may just want to clean up your data to make it consistent across the document. Excel provides three quick formulas to accomplish the text-case [...]
Calculate Age in Excel
Using a combination of built-in functions in Excel, you can quickly calculate a person’s age. There are a couple different ways this method can be used, and we’ll go through both below.
Check if a Cell Contains Text
Excel provides an easy method to determine if a particular cell contains text. Using the IsText function will return True or False after checking the given cell. Let’s take a look at at how to use this function. IsText Example For this example, let’s imagine Cell A1 has the text “Red”, and Cell B1 contains [...]
Functions or PivotTable?
Microsoft’s Excel Blog has an interesting post breaking down the advantages of using either functions or pivotTables to do your analysis. There present the differences with a small example. Check out the comparison here: Analyzing Data: Functions or PivotTables
Separate Full Name into First & Last Name
Here are two easy formulas that will separate a cell that contains a full name (first and last name format) into 2 cells – one containing the first name and the other containing the last name. To do this we are going to make use of the left, right, len & find formulas.
