LEFT Function

« Back to Glossary Index

This Excel function grabs 1 or more characters from a text string or cell reference from the left. The formula is useful if trying to grab initials from first names or creating account numbers. The function has 2 arguments.

Argument	Description
Text	Indicates a cell reference or text.
Num_chars (optional)	Indicates the number of characters to be retrieved. If no value is provided, Excel defaults to 1

Syntax Example	What Happens
=LEFT(A2)	This would retrieve the left-most character from cell A2, which would result in “J”.
=LEFT(“starborm”,4)	This would retrieve the left-most 4 characters from “starborm” which would result in “star”.

« Back to Glossary Index