Select Page

Excel Video 161 REPT

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...

Excel Video 160 TRIM

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....

Excel Video 159 UPPER, lower, and Proper

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...

Excel Video 158 Combining Text 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...

Excel Video 157 MID

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...