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 uses MID to extract the first name from our list of patients. LEFT helped us retrieve the...

Now that we’re familiar with LEFT, RIGHT, and MID, Excel Video 158 combines FIND and LEN into one formula...

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 covers another easy Excel function. This time we’ll use TRIM. TRIM simply removes extra...

Excel Video 161 helps you repeat helps you repeat text as many times as you want you want. I don’t use the...

Excel Video 162 helps you convert text to values and values to text. Before Excel 2007, I used the VALUE and...