left
What is the use of Left formula? Cuts a text from left Syntax of Left formula: left(from this text, this many letters) Examples of Excel Left formula: left("Pointy Haired Dilbert rocks", 6) = Pointy left(A1,5) = first five characters in the cell A1