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:

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 »
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 »