Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

LEFT

Returns characters from the left side of a text string in Excel
Get left side of a text string.

Rational

Find characters from the left side of a text string.

Description

The Excel LEFT function display number of characters specified in the argument of text starting from the left. For example, LEFT(“Excel LEFT function”,5) returns “Excel”.

Syntax

= LEFT (text, [num_chars])

Parameters

text – The text that contains the characters
num_chars [Optional] – Number of characters to extract.

Return Value

One or more characters

Key Notes

  • Use the MID and RIGHT function to extract a specific number of characters based on given starting and rightmost positions respectively.
  • The LEFT function also extracts digits from a string.
  • The num_chars is optional and defaults to 1.
  • If the reference argument is blank the return value will also be empty.

Keep Reading Similar Functions:

Returns characters of a text string from the middle in Excel

MID

The MID function extracts a specified number of characters from the middle of a given text string. For example, =MID(“number”,1,3) returns “num”.

Read More »
Get rightmost characters from a text in Excel

RIGHT

The Excel RIGHT function extract rightmost characters based on the specified number. I.e., =RIGHT(“String”,4) returns “ring”.

Read More »
Join multiple texts with a delimiter in Excel

TEXTJOIN

The TEXTJOIN function allows concatenating (join) the text from multiple ranges with a delimiter between each text value. E.g., =TEXTJOIN(” ,”,TRUE,”Blue”,”Green”,”White”,”Black”) return ” Blue ,Green ,White ,Black”.

Read More »