LEFT and RIGHT are string formulas for working on text. You use them when you want to extract some parts of a text. LEFT returns a number of characters of a cell, starting from the left hand side. RIGHT does exactly the same, but starts from the right hand side.
Let's excel in Excel