Left Right Formula in Excel displays a specified number of characters from the left/right-hand side of a piece of text or extracts part of contents of cell.