by Nate Moore | May 25, 2011 | Functions
Excel Video 160 covers another easy Excel function. This time we’ll use TRIM. TRIM simply removes extra spaces from text. Older data systems occasionally filled any extra space at the end of the data with actual spaces. TRIM is an easy way to get rid of those spaces....
by Nate Moore | May 23, 2011 | Functions
Just in case you want to change the case of your data, Excel Video 159 has three easy functions to do just that. UPPER changes all of the text to upper case. LOWER changes all of the text to lower case (especially helpful if you want your data to look like most of the...
by Nate Moore | May 18, 2011 | Functions
Now that we’re familiar with LEFT, RIGHT, and MID, Excel Video 158 combines FIND and LEN into one formula that doesn’t require the extra columns for FIND and LEN that we’ve used in the past Excel Videos. When you first see the combined formulas, you’ll probably wonder...
by Nate Moore | May 16, 2011 | Functions
Excel Video 157 uses MID to extract the first name from our list of patients. LEFT helped us retrieve the patients’ last names and RIGHT got the patients’ first names and middle initials. Now we’ll use MID to just get the patients’ first names. MID requires three...
by Nate Moore | May 11, 2011 | Functions
RIGHT works just like LEFT did in Excel Video 155 with similar parameters. First, you tell Excel where the text string is you want to extract characters from. Second, you tell Excel how many characters to extract. The trick with RIGHT is knowing how many characters to...
by Nate Moore | May 9, 2011 | Functions
You’ll be LEFT behind if you try to extract a patient’s last name without watching Excel Video 155. The LEFT function has two parameters. First, enter the text string you want to extract text from, which in our example is the cell with the patient’s full name. Then,...
