Sometimes, you need to change text in a systematic way: If you want to replace some text with new text, there are two options. If you only want to do it once, using the Find-and-Replace dialogue is probably the fastest choice. If you want to do it repeatedly or don’t want to mess with your input data, you should try the SUBSTITUTE formula.
You need to know how many characters does the cell contain?
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.