Do you know the structure and usage of the LEFT function in Excel?

What is the LEFT function in Excel used for? What is the structure and usage of this function?

Want to cut off a number of characters in any one cell and then apply it to other cells?You can use string truncation operations such asLEFT , RIGHT , MID.This article will introduce the syntax and usage of LEFT function in Excel.

1. The Left function structure in Excel

LEFT ( text, [numchars] )

Inside:

+ text- original character string

+ numchars- the number of characters you need to cut from the original character string from the left to

2. How to use the Left function in Excel

Suppose you have a cell B3 (yellow) with the year - month - day format written together. If you only need to extract the year from cell B3 , you can use the LEFT function by entering cell C3 (in orange) next to the structure: = LEFT (B3,4) , then press Enter . Then, cell C3 will show 2015 results as shown in the picture.

Do you know the structure and usage of the LEFT function in Excel? Picture 1

Let's analyze the structure of this statement:

LEFT (B3,4) = LEFT ('20151219', 4) , meaning you will take 4 characters from the left to the right as in the picture:

Do you know the structure and usage of the LEFT function in Excel? Picture 2

And the result you get is 2015 .

Similarly, if you want to get 5 characters from the left, you type the formula: LEFT (B3,6) and the result you get is 201512

3. Some notes when using the Left function in Excel

+ The number of characters you need to get must be greater than 0, meaning that if you enter the cell using the formula: = LEFT (B3, -1) , you will get the #VALUE error.

+ In the above string, there are 8 characters, if you enter the cell using the formula: = LEFT (B3,10) , the result you get is 20151219 , even if you want to cut 10 characters as in the medium formula. import.

+ If you do not enter the formula for the number of characters to cut in the string from left to right, its value will default to 1. For example, you enter the cell as: = LEFT (B3) , then Excel will understand are: = LEFT (B3,1) = 2 .

3.5 ★ | 2 Vote

May be interested

  • OR function in Excel, how to use the OR function, and examplesOR function in Excel, how to use the OR function, and examples
    the following article details the meaning and usage of the or - logic function in excel. description: the or function is a function that returns the logical value in excel.
  • How to use the FIND function in Excel?How to use the FIND function in Excel?
    the find function in excel is a function that finds characters in a text string, having the same purpose as string separators like the mid function in excel or the left function or the right function.
  • PMT function in Excel - Usage and examplesPMT function in Excel - Usage and examples
    the pmt function is one of the built-in financial functions of the excel software used to calculate the payment for a loan based on regular payments and a constant interest rate. the pmt function is not only useful for businesses, but also very practical for users if you want to calculate a loan.
  • LEFT function in SQL ServerLEFT function in SQL Server
    the left function in sql server allows you to extract a substring from a large string, starting from the leftmost character.
  • T.DIST - The function returns the Student t-distribution on the left in ExcelT.DIST - The function returns the Student t-distribution on the left in Excel
    t.dist: the function returns the student's t-distribution on the left. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist (x, deg_freedom, cumulative)
  • Match function in Excel - Usage and illustrative examplesMatch function in Excel - Usage and illustrative examples
    the match function in excel finds a specified item in a specified range and, returns the relative position of that value in this range. function syntax and usage syntax: = match (lookup_value, lookup_array, [match_type]). in which: - match: is the function name. - lookup_value: is the value to search, be it text or numeric.
  • DCOUNT function in Excel - Usage and practical examplesDCOUNT function in Excel - Usage and practical examples
    the dcounta function is one of many frequently used math functions in excel. the dcount function helps you count non-blank data cells in list columns or data arrays with defined conditions.
  • IFERROR function in Excel, formulas, and usageIFERROR function in Excel, formulas, and usage
    the iferror function in excel corrects a formula error, returning a different value that replaces the error message in the normal way.
  • IF function in ExcelIF function in Excel
    the if function is a common function in excel, the following article describes the syntax and usage of the if function.
  • Basic Excel functions that anyone must knowBasic Excel functions that anyone must know
    the basic functions in excel such as the excel function, the excel statistics function we summarized below will be very helpful for you who often have to work on excel spreadsheets, especially in the field of accounting. let's refer to offline.