by Nate Moore | May 30, 2011 | Functions
Excel Video 161 helps you repeat helps you repeat text as many times as you want you want. I don’t use the REPT function as much as I used to, but there are a few instances when you may find it helpful. Essentially REPT repeats whatever text you enter (remember to put...
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...
