How to Use the Text Functions in Excel: LEFT, RIGHT and MID. 

This video explains the use of the LEFT, RIGHT and MID text type functions in Excel.
The explanation is done working with a group of data, the LEFT and RIGHT functions are also combined to show how by combining these functions you can do more complex things.