Excel LEFT formula - Examples of Excel Left formula

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

<< Find I Left I Len >>




That’s all for now. If you want to add any tip then feel free to comment below. Thanks. And Subscribe to blog feed to receive updates about new posts !