
Text Functions Playlist
Excel Video 155 LEFT
You’ll be LEFT behind if you try to extract a patient’s last name without watching Excel Video 155. The...
Excel Video 156 Right
RIGHT works just like LEFT did in Excel Video 155 with similar parameters. First, you tell Excel where the...
Excel Video 157 MID
Excel Video 157 uses MID to extract the first name from our list of patients. LEFT helped us retrieve 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...
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...
Excel Video 160 TRIM
Excel Video 160 covers another easy Excel function. This time we’ll use TRIM. TRIM simply removes extra...
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...