ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Functions > Excel LEFT Function

Excel LEFT Function

How to Use the Excel LEFT Function
Table of contents :
  • What is the Excel LEFT Function?
  • LEFT Syntax
  • How to Use LEFT Function in Excel
  • LEFT Example

Excel LEFT Function

What is the Excel LEFT Function?

The excel LEFT function takes a number of characters in the text from the left.

LEFT Syntax

LEFT(text, [num_chars])

text, required, the text from which to extract the characters.

num_chars, optional, specifies the number of characters to extract.

  • If you omit the num_char argument, it is assumed to be 1.
  • If the num_chars argument is larger than the length of the text, you got the text
  • If you put a negative number on the num_char argument, you got a #VALUE! error

How to Use LEFT Function in Excel

The following is an example of the LEFT function usage and the results

Excel LEFT Function

LEFT Function #1

=LEFT(A2,0)

You got nothing if you put zero number on the num_char argument.

LEFT Function #2

=LEFT(A3,3)

Nothing special. You fill number 3 in the num_char argument; then you get the first three letters of the abcde text.

LEFT Function #3

=LEFT(A4,1000)

Regardless of how you fill the num_char argument, if it is larger than the text length, you got the same text.

LEFT Function #4

=LEFT(A5,-1)

You get the #VALUE! Error if you fill a negative number in the num_char argument.

LEFT Function #5

=LEFT(A6,2)

The LEFT function can extract the alphanumeric value because alphanumeric is a text.

LEFT Function #6

=LEFT(A7,2)

The LEFT function can extract numeric values too. Both alphanumeric or numeric values the LEFT function return the same result.

LEFT Function #7

=LEFT(A8,2)

Whatever the format cell applied to a number, the LEFT function ignores it and only extracts the number.

LEFT Function #8

=LEFT(A9,2)

Why LEFT function returns the same result as the previous 3 LEFT functions for date value 1/1/2019? Excel stores date values in an integer number. Date 1/1/2019 is the same as number 43466.

Read the following article for a more detailed explanation of how Excel stores date and time values

  • How does excel stores date and time

LEFT Function #9

=LEFT(A10,2)

Why the LEFT function returns the different results for cell A10? Cell A9 contains a date, but cell A10 contains a text. LEFT function counts slash line for text values.

The otherwise, date (day, month and year) and slash line is the format of the cell, not the data. The actual data is an integer number.

LEFT Function #10

=LEFT(A11,3)

The LEFT function can extract decimal numbers too. LEFT function count decimal separator as one character.

LEFT Function #11

=LEFT(A12,3)

Why does 1:00:00 PM give the same results as the previous LEFT function? Excel stores date values as integer numbers, and for times values Excel stores as a decimal number.

Read “How does excel stores date and time” for a detailed explanation.

LEFT Example

Another article using or explain about LEFT Function
  • Add and Remove Leading Zeros in Excel
  • How to Combine and Separate First and Last Name in Excel

Another Text Function

Another article about Text Function
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
Usefull links
  • Microsoft LEFT, LEFTB function documentation
Share
Tweet
Google+
Email
Prev Article
Next Article

Related Articles

Excel Concatenate Function
What is the Excel CONCATENATE Function? The excel CONCATENATE function …

Excel CONCATENATE Function

Excel CONCAT Function
What is the Excel CONCAT Function? The excel CONCAT function …

Excel CONCAT Function

Excel IFNA Function
What is the Excel IFNA Function? The Excel IFNA function …

Excel IFNA Function

Excel Month Function
What is the Excel MONTH Function? The Excel MONTH function …

Excel MONTH Function

How to Use OR Function in Excel
What is the Excel OR Function? Excel OR function used …

Excel OR Function

Tags:Excel LEFT Excel LEFT Find Excel LEFT of Character Excel LEFT RIGHT Functions Excel LEFT RIGHT MID How to Use LEFT Formula in Excel How to Use LEFT Function in Excel How to Use LEFT in Excel LEFT and RIGHT Excel LEFT and RIGHT Function in Excel LEFT Command in Excel LEFT Formula Excel LEFT LEN Excel LEFT RIGHT Formula Excel Text Functions

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • Get the Original Price from Percentage Increase/Decrease
  • How to Add/Subtract Percentage in Excel
  • How to Extract Day, Month and Year from Date in Excel
  • How to Add Seconds, Minutes and Hours to a Time in Excel
  • How to Add Days, Weeks, Months and Years to a Date in Excel
  • How to Calculate Time Difference in Excel
  • Calculate Number of Days, Weeks, Months and Years Between Two Dates in Excel
  • Flash Fill Excel
  • Paste Special Excel
  • Excel TEXTJOIN Function
  • Excel CONCAT Function
  • Excel CONCATENATE Function
  • Excel REPLACE Function
  • Excel SUBSTITUTE Function
  • Excel REPT Function
  • Excel FIND Function
  • Excel SEARCH Function
  • Excel MID Function
  • Excel RIGHT Function
  • Excel LEFT Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2023 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh