What is the use of LEFT function?

LEFT Function in Excel returns the first or left most character(or Characters) in a text string.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Ultimate Project Management Template
Excel Template

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


LEFT Function in Excel syntax

Syntax of LEFT function:

LEFT(text,

[num_chars])

Where

text – Is the text string contains the characters you want to extract.
num_chars – Its optional argument.The number of characters you want to extract. If this parameter won’t     declare, Only one character is returned.

LEFT Function in Excel- Examples

LEFT Function in Excel - Example 1

Example 1: It will return first four characters from the text string.
Example 2: It will return ten four characters from the text string.
Example 3: In this case, blank also consider as single character
Example 4: It will return first nine characters from the text string.
Example 5: The num_chars is more than the length of string, then it will return original text string.
Example 6: The num_chars should be more than “Zero”, otherwise it will through error.
Example 7: If num_Chars left balnk, only 1 character is returned from the left side of string

VBA example on LEFT function

LEFT function is also available in VBA, following is the example code:

Dim sOutout As String
sOutout1 =LEFT(“Analysis Tabs “, 8)

Output: “Analysis”

LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template

 
Related Resource External VBA Reference