LEFT Function in Excel

Home/Excel Formulas/LEFT Function in Excel

What is the use of LEFT function?

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



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

LEFT Function in Excel syntax

Syntax of LEFT function:




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(“mongopono.ru “, 8)

Output: “Analysis”

By |January 10th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

Related pages

excel userformbreak statement in vbavba excel eventsmacro msgboxprogrammer analyst interview questions and answerspastespecialexcel vba user formsconsolidate excel filesdelete blank cells excelms excel vlookup examplesconcatenate excel formulasave xlsm as xlsxremove duplicate data in excelsimple gantt chart template exceldatabase macroshow to sort an excel spreadsheetexcel function syntaxinfosys interview questions and answers for freshersvba using excel functionsexcel vba windowshow to do pivot table in excel 2010advanced excel charts tutorialadvance excel 2010excel developer modeexcel macro userformeliminating duplicates in exceladvanced filter vbaexcel sql connectionexcel len functionexcel vlookup function examplesexcel rgbinteractive chart exceloffset function excelcoding macros in exceldashboard excel tutorialexcel formula hlookup exampleconcatenate excel worksheetscreateobject vbavba recordunmerge vbaexcel vba programming ebookvba range clearexcel remove repeatslock hidden columns in excelvba meaningvba instr functionexcel 2010 hyperlinks change to local pathsql queries interview questions and answers pdf free downloadexcel password workbookcell color in vbaexcel check duplicatevlookup with truecopy sheet vbafilesystemobject propertiesexcel unprotecthow to combine cells in excel 2007excel vba write filewhat is col index num in vlookuphow to set macro security in excel 2010if condition in excel 2007rows vbabasic excel macroshow to run sql in excelduplicates in excel columnhow to collapse rows in excelexcel combine duplicate rowsexcel application.matchclear cells vbaexcel nested if statementsunlock vba projectvba textbox valuemacro msgboxpastespecial pastehow to remove the duplicates in excel