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

vba define functionformula replace excelexcel merge columsexcel macro dimworkbooks.activateadvanced excel shortcut keysunprotect vbavba positionexcel 2007 sumifconcatenate formulacheck if workbook is open vbaweekly report template pptvba deleteexcel macro graphexcel months between two datesinsert row excel shortcutinfosys interview questions and answers for freshersvlookup easy stepshow to see developer tab in excel 2010multiple stacked bar chart excel 2010refresh all pivot tables vbaoffset command in excelrange excel vbacopy paste in vbavba delete columnvb.net excel saveashow to merge tabs in excelchart wizard in excel 2010excel bubble chartexcel multiple conditionstick boxes excelhow to check duplicate values in excelcreate pivottabledelete macros in excelhow do i unlock an excel spreadsheetexcel vba cellsconvert excel to xmlvba chr listbubble graphs in excelsimple vlookup formulappt schedule templatewhat is macros in excel 2007vba columnsproject tracking dashboard templatesendmail command examplemicrosoft excel vlookup tutorialnested if condition in excelsimple v lookuphow to paste special in excelhow to unhide an excel columnexcel formulas lenexcel contains stringexcel vba printvb6 write text filesql basics for beginnersexcel vba tutorialmsgbox input vbaunprotect sheet forgot passwordschedule template powerpointvba introductionexcel vba character codeshow to unmerge cells in wordhow to shift columns in excelexcel vba merge workbooksmicrosoft excel 2007 exam questions and answersexcel vba sumifvba coding basicshow to change macros in excelremoving empty rows in exceladodb connection providerhow to lock an excel filevba select foldertimeline templates excelexcel drop down macrouse of hlookup in excelvba excel workbookhow to unhide a cell in excelexcel identify duplicate rowssql telephonic interview questions